You need to sign in to do that
Don't have an account?
Sahil Yadav
Close Date is getting changed while updating from Dataloader
Hello folks,
while inserting data from data loader into the object lead .
closedate is a datetime field whose date is getting changed
Any Suggestion how can we correct this close date so that its get mapped correctly an expected date as per csv??
while inserting data from data loader into the object lead .
closedate is a datetime field whose date is getting changed
Any Suggestion how can we correct this close date so that its get mapped correctly an expected date as per csv??
Check similar issue below and try workaround mentioned.
https://salesforce.stackexchange.com/questions/139110/data-loader-updates-date-value-incorrectly
Please mark as Best Answer if above information was helpful.
Thanks,
If you want to date in salesforce then you need to formate the CSV file.
For this please check the Default Time Zone of your org from company information. Ex:- (GMT+05:00)
First formate the column as salesforce defined YYYY-MM-DDThh:mm:ssZ anf then follow the below step.
lets suppose your date column in excel is "A" then write a formula in column "B" =A:A-(5/24). and save the file then insert or If you inserted data then you can update date time with the help of Id of record.
Be sure If you have defauly time zone is in positive - Like (GMT+05:00) then you need to put formula as Negative like A:A-(5/24) and if you have time zone is in negative Like :- (GMT-05:00) then you need to put formula as Positive A:A+(5/24).
Please mark as Best Answer if above information was helpful.
Thanks&Reagards,
Syed Jabeena