Date formats

When doing an import, it looks like the date format and culutre is totally independent of each other. That is not exactly true.

The date format is however depending on the Culture (above set to en-US). As stated in the reference manual:

/

The date separator.

(according to the set Culture)

6/15/2009 1:45:30 PM -> / (en-US)

6/15/2009 1:45:30 PM -> - (ar-DZ)

6/15/2009 1:45:30 PM → . (tr-TR)

This means, that when choosing Turskish culture, the importer will expect the date seperator to be a dot. Similiarly, when choosing Swedish, the importer will expect the date separator to be a dash "-".

If you get an odd file such as this, where you have a British date format and a Swedish number format this will cause an issue.

201-204 15/01/2018 21:55:00 1728,3
201-203 15/01/2018 17:00:00 1619,8

There is however a workaround for that, by using the escape character.

dd\/MM\/yyyy

Redbex Knowledge Base