I'm having an issue when uploading a date from a csv via DataLoader. The date on my csv is for example 2017-04-03, but when uploading it via DataLoader, it will be 2017-04-02 in SF (always one day less).

The SF field is a Date field, not Date/time.

Any idea of what could be the problem? I'm trying to check the DataLoader settings but I'm on MacOS and nothing happens when I click "Preferences".

Thanks, /Y

2 Answers 2


You are facing a timezone issue and will need to modify the PC's time zone.

Here is some information from a Knowledge Article with 2 possible solutions.

Two simple solutions to this are:

1) Specify a time as well as a date when loading dates using the Data Loader

2) Switch your PC's time zone to Hawaiian time before starting up the Data Loader.

  • Thanks, adding a time works, but changing my MAC's time zone didn't.
    – Yaya
    Commented Apr 11, 2017 at 12:38
  • Cool. Sounds like SF is expecting DateTime from your load. Glad you got it resolved.
    – TSmith
    Commented Apr 11, 2017 at 13:00

Please use the below date format to upload data through data loader: mm/dd/yyyyThh:mm:ssZ

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .