Importing CSV date information into Insight

[Bryn Koning]

When i import date fields from a CSV file they automatticlly interpret the date in US format if the day is less than 13.

If I import 03/12/2022 (dd/mm/yyyy) the date is interpreted as 12/Mar/2022 

If I import 13/12/2022 (dd/mm/yyyy) the date is interpreted as 13/Dec/2022

The CSV file is formatted as dd/mm/yyyy

If I change th einput date record to mm/dd/yyyy format it translates the dates correctly (but as I am not in US it i sof no use to me)

? 

[Bryn Koning]

If i refeormat the input date field to YYYY/MM/DD the date is interrogated correctly, however this requires pre-processing prior to the importation of the data?

Anyu other thoughts?