+ Start a Discussion
shahid alishahid ali 

Date entered is not correct

hello,

 

 

I have few date fields in my objects. I m inserting the data using data loader from the excel sheet. But whatever date fields are there in the excel sheet, are not matching with those in the objects. All the values are 1 day less than what are entered. Any reason for this?

 

Thanks in advance.

Best Answer chosen by Admin (Salesforce Developers) 
AravindBabu512AravindBabu512

Hi,

 

Please check the time zone settings in your org. This could be one of the issues, as the data in your spreadsheet will be of a time zone that is different than what you have in your org.

 

Thanks,

Aravind