+ Start a Discussion
Zabi MohammedZabi Mohammed 

Date Format

Hi all,

  I am facing a proble with date when i upload a csv file in to salesforce in csv file i having the date filed as 9999/01/01,
when i am trying to upload the file its showing invalid date can u pleas help me on this.

thanks,
zabi
Best Answer chosen by Zabi Mohammed
surasura
Only dates within a certain range are valid.
The earliest valid date is 1700-01-01T00:00:00Z GMT, or just after midnight on January 1, 1700.
The latest valid date is 4000-12-31T00:00:00Z GMT, or just after midnight on December 31, 4000.
Note
These values are offset by your time zone. For example, in the Pacific time zone, the earliest valid date is 1699-12-31T16:00:00, or 4:00 PM on December 31, 1699.

for more information refer https://success.salesforce.com/answers?id=90630000000gh4yAAA

All Answers

surasura
Only dates within a certain range are valid.
The earliest valid date is 1700-01-01T00:00:00Z GMT, or just after midnight on January 1, 1700.
The latest valid date is 4000-12-31T00:00:00Z GMT, or just after midnight on December 31, 4000.
Note
These values are offset by your time zone. For example, in the Pacific time zone, the earliest valid date is 1699-12-31T16:00:00, or 4:00 PM on December 31, 1699.

for more information refer https://success.salesforce.com/answers?id=90630000000gh4yAAA
This was selected as the best answer
yogesh_sharmayogesh_sharma
Hi Zabi,
If you are using Data loader for upload your CSV, in this case you can go setting in data loader and check Europian date format(dd/mm/yyyy). Or you can directly put your date value in this format(07/17/1945).
I hope this will help you and let me know if you need any additional information.
 
Zabi MohammedZabi Mohammed
thans to all