You need to sign in to do that
Don't have an account?
SalesRed
Can Date Formats Take Time Zone Settings Into Consideration When InsI just thoguht erting Via SOAP?
Hello,
I just thought I'd post a question to confirm something which has come up for discussion and which I did not consider as being a possibility when inserting data.
- I have a client which is inserting data into a custom object via the Standard Soap API and dates they enter are not corresponding to their thoughts on how the data should be entered. The value is enterering with a value 1 day less than the dates they provide. The clients timezone is GMT + 8 hours.
- To my understanding the date should enter exactly as it's provided in the XML as it's not a Date/Time field and timezone is irrelevant.
- I've asked the client to provide the SOAP XML in order that I can verify what is provided is different than the final value in SFDC but the client is unable to provide the XML (for some reason debugging cannot be setup for this).
On testing this myself using SOAP UI & changing my SFDC User's timezone & even changing the time for my own laptop the value I enter in the SOAP request inserts exactly as I enter it without any changes.
I note the following details that issues can occur with dataloader sometimes. I presume it's correct that no impact can occur for dates when inserting via a SOAP request? That dates should just enter exactly as received.
https://help.salesforce.com/HTViewHelpDoc?id=faq_import_general_wrong_date.htm&language=en_US
Thanks for any help clarifying on this.
I just thought I'd post a question to confirm something which has come up for discussion and which I did not consider as being a possibility when inserting data.
- I have a client which is inserting data into a custom object via the Standard Soap API and dates they enter are not corresponding to their thoughts on how the data should be entered. The value is enterering with a value 1 day less than the dates they provide. The clients timezone is GMT + 8 hours.
- To my understanding the date should enter exactly as it's provided in the XML as it's not a Date/Time field and timezone is irrelevant.
- I've asked the client to provide the SOAP XML in order that I can verify what is provided is different than the final value in SFDC but the client is unable to provide the XML (for some reason debugging cannot be setup for this).
On testing this myself using SOAP UI & changing my SFDC User's timezone & even changing the time for my own laptop the value I enter in the SOAP request inserts exactly as I enter it without any changes.
I note the following details that issues can occur with dataloader sometimes. I presume it's correct that no impact can occur for dates when inserting via a SOAP request? That dates should just enter exactly as received.
https://help.salesforce.com/HTViewHelpDoc?id=faq_import_general_wrong_date.htm&language=en_US
Thanks for any help clarifying on this.
Whatever the time format you give SOAP request assumes as GMT format and Inserts.
The displayed format will be in users Time zone.
If user is inserting in GMT+08:00, salesforce assumes it in GMT and finally dispalys it in Users time zone (ex.GMT+09:00).
Because of this you may see different dates in Client side and SF side.
Thanks,
Naveen,
http://www.autorabit.com