function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
sapsap 

Date change while loading data using apex loader

Hi,
 
Im loading data using apex loader.But i m facing some problem when the data is of type DATE.It is reducing by one day and some times by one month.Im not able to trace the problem.Can any one please help me out in resolving this issue.
 
Thanks in advance.
benjasikbenjasik
see the data loader docs on date formats

"If your computer’s locale is east of Greenwich Mean Time (GMT), we recommend that you change your computer setting to GMT in order to avoid date adjustments when inserting or updating records. A knowledge base solution for this issue is available in the Salesforce Help & Training window; search for "data loader date."
MatMMatM
I have set all of my time settings and I still seem to experience problems with dates.
 
I have 1 complete file that i have loaded,
 
Some of the dates have loaded exactly as they are in the file, some have loaded a day earlier and some a month earlier.
 
What on earth is causing this issue, its a real pain in the neck for me as we have workflow rules that trigger from specific dates.