ForumsTips & TricksDate Errors in Import of SCV File


Date Errors in Import of SCV File
Author Message
GMB

Posted: Jun 05, 2009
Score: 0 Reference
When I import a CSV file from Outlook the due date of 5/6/2009 is read into Toodledo as May 2006. Can you fix this?
Anders

Posted: Jun 05, 2009
Score: 0 Reference
I have used the CSV import, and never seen anything like this. How exactly is the date formatted in your file? It doesn't make any sense at all for it to come out as 2006.
GMB

Posted: Jun 05, 2009
Score: 0 Reference
The date in the CSV file is shown as 5/6/2009. Toodledo appears to only read the 5/6 thus interpretating this as May 2006
GMB

Posted: Jun 05, 2009
Score: 0 Reference
The date in the CSV file is shown as 5/06/2009
Anders

Posted: Jun 05, 2009
Score: 0 Reference
I did not realize the import tool was so picky about date formatting. If you format it thusly, 2009-05-06, it will work. I don't know if that is the only accepted format, but I know it works.

~Anders
Anders

Posted: Jun 05, 2009
Score: 0 Reference
Also, I do not know if it will make a difference, but you could check your "date format" setting in "Your Date/Time" under "Account Settings", and make it match your file.

~Anders
GMB

Posted: Jun 05, 2009
Score: 0 Reference
Trying that but does not seem to make any difference
Jake

Toodledo Admin
Posted: Jun 05, 2009
Score: 0 Reference
Yes, make sure it is in the YYYY-MM-DD format for the best success. We are working to recognize more formats.
You cannot reply yet

U Back to topic home

R Post a reply

To participate in these forums, you must be signed in.