ForumsTips & TricksDate Errors in Import of SCV File
Date Errors in Import of SCV File
| Author | Message |
|---|---|
|
GMB |
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 |
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 |
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 |
The date in the CSV file is shown as 5/06/2009
|
|
Anders |
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 |
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 |
Trying that but does not seem to make any difference
|
|
Jake Toodledo Founder |
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.