Import from Excel - Date not working
I am trying to import data from Excel. I exported my data from a ZoHo view to make sure I have the correct headings and columns. When I try to import the same file which I just exported, everything works fine except the Date.
My Date field is a Date-Time. It exports to excel as "Apr 07, 2010 23:27:28". The cell is formatted as "
mmm dd,yyyy hh:mm:ss" When I try to reimport this same exact file back into Zoho creator, the date time field is blank.
I have tried to change the format in excel to almost everything I have found on this forum, like
mmm dd,yyyy hh:mm:ss
dd mm yyyy hh:mm:ss
mmm dd,yyyy hh:mm:ss
yyyy-mm-dd hh:mm:ss
The date field always comes up blank, while all other fields work perfectly.
Thank you for any help.