← All articles

Importing data — How dates are read (2)

On the review step, a note under each date column shows one date that could be read two ways and how it will be read. A picker switches between Day first and Month first, and where dates have no year a box sets the year they take. The note also counts values that are not dates. Those are kept as written, never dropped, and the confirmation screen counts them again for the whole file. The counts in the note come from the rows the analysis reads. In a longer file the whole column is read when you import, and unless you chose an order yourself, a date further down that can only be read one way decides it.
Nothing here answered it? Ask us directly — we usually reply within one working day.

Made with RowFold