Hi
I'm importing a small file to a custom object. There is an expiry date which maps to a date-time field, and the expiry time should be 11.59pm.
Our org is set to GMT+10 and my user is set to GMT+10. I have set the expiry date time to 13:59 to account for the 10 hour offset. Sometimes this imports as 11:59pm and sometimes as 10.59pm. There doesn't seem to be any consistency as to which it imports as. I've tried using the Data Import Wizard and
Dataloader.ioand get the same inconsistent results.
Sample format: 2028-07-12T13:59:00Z
Does anyone have any ideas on other things to check?
Thanks
#Import Data Challenge
Hi,
insert one test record then, Adjust your data according to time zone (+-).
https://help.salesforce.com/s/articleView?id=000385167&type=1