Apex Code Development You need to sign in to do that
Don't have an account?
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
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
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
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
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.