Import > Delimited text import > Import datetime format

Date format in source file

When importing data from a text data source file the date format used in the source file must either comply with the available date formats of the current Windows systems settings (Windows Control Panel) - or it should be in the ISO date format.

PdxEditor will thus accept any dates compliant with the current system date format settings whatever being of any of the MM/dd/yy, MM/dd/yyyy, dd.MM.yy, dd-MM-yyyy, etc. formats.

To ensure correct date import interpretation independent of the system settings the source date format should be in the yyyy-MM-dd format, which is also the recommended export format.

DateTime format in source file

As for date imports, importing DateTime values these must comply with the current system date format or be of the ISO DateTime format.

Import will thus whatever the system settings accept DateTime values in the ISO format:
YYYY-MM-DD hh:mm:ss
as well as the ISO 8601 format using 'T' as a dato vs. time separator:
YYYY-MM-DDThh:mm:ss
However, fractions of seconds are ignored.