I trying to import a simple spreadsheet with 4 columns into a table, one of which is a date.
If the table doesn't yet exist, "text" is assumed as data-format for all columns and there is no attempt to parse the date at all.

Next I defined the table before importing with column number 4 as "date".
On the first try the date-format was "mm/dd/yyyy" which resulted in very funny dates +/- 30 years from now.
The next try used format "yyyy-mm-dd" which got me the correct date in the first row, and the same date for all following rows - which obviously also isn't correct.

It would be cool if we could define the date-format for imports, but I could live with converting the output to the csv-file to the right format, if I got the correct date on all rows.

Comments

ray007’s picture

ray007 commented

Actually, I have to correct myself. The date in the first row of the 2nd import-try also wasn't correct - it only looked sane.

pobster’s picture

pobster commented

Hmmm dunno how I missed this issue, don't ever remember reading it before...

Anyways, the dates are stored as 2007/7/4 so that's exactly how you'd go about importing them.

I am considering allowing in the settings some sort of regexp to help with importing. It's not important to me I'm afraid so it's very low on my list of things to do...

Pobster

pobster’s picture

pobster commented
Status: Active » Closed (fixed)