Importing dates doesn’t work
I have the same problem! All dates on the form, no matter what format, gets imported as zeroes.
When importing a date, I tried 5 different formats from an Excel Spreadsheet.
6/5/2016 12:00:00 AM
The two options that worked are '06/02/2013 and 6/3/2013. The first is seen by Excel as text because of the apostrophe in the beginning. The second was entered as 06/03/2013 and the date functionality of Excel auto formatted it to 6/3/2013.
I found a solution that seems to work (for me at least) and is easy to implement. If you right click on the date and go to Format Cells>Date, the Excel default date format of *03/14/2001 was used. The explanation for the * is given below the date options but it basically means that it uses your computer’s regional settings to determine the date format. This seems to cause the problem. I changed all the dates to use a date without the * (like 3/14/2001 near the bottom of the list) and then the dates uploaded properly.
If you would like to submit an answer or comment, please sign in to the eOne portal.