I’m trying to import CSV data from Wordpress, one of the fields being the date of the post. Now I have the dates in the CSV, bur when I try to map the column, I don’t see date as an option (not even as a greyed out option) in the dropdown list.
Year:
YYYY (eg 1997)
Year and month:
YYYY-MM (eg 1997-07)
Complete date:
YYYY-MM-DD (eg 1997-07-16)
Complete date plus hours and minutes:
YYYY-MM-DDThh:mmTZD (eg 1997-07-16T19:20+01:00)
Complete date plus hours, minutes and seconds:
YYYY-MM-DDThh:mm:ssTZD (eg 1997-07-16T19:20:30+01:00)
Complete date plus hours, minutes, seconds and a decimal fraction of a
second
YYYY-MM-DDThh:mm:ss.sTZD (eg 1997-07-16T19:20:30.45+01:00)
…so I thought my YYYY-MM-DD would do too
I also noticed that my WP exporter does something weird: it exports to 2001-Feb-Thu instead of 2001-02-08. I was stubborn enough to just give that a try, but that didn’t work of course
I changed the export and the dates now read
2001-02-08T11:00+01:00
But alas, still no date option to select in the dropdown…
I actually “fixed” it by adding a date field. Since all posts have a webflow created on date I assumed it would be possible to populate that but that doesn’t seem to be an option. I manually added a date field and I was able to populate that one. I now have to manually add a date to each post but at least it works