Issue with dates being read as American dates
I am pulling in my source data with a column that contains dates of the format dd/mm/yyyy. When annotating the columns, I have specified the column to be a date column. Now ready to explore my data, most of the dates in the column have correctly loaded in format dd/mm/yyyy. However some have converted to format dd-MMM-yyyy and infact it has switched the day and the month before changing format. So for example in my source data I have the date 03/11/2020 is appearing as 11-Mar-2020 in Aperture. I believe this is happening because Aperture is reading the date in American date format (and so switching the days and months for those where the day is between 1-12 and those corresponds to a correct date). I have checked and my internet browser language is in english UK. How can I stop my dates being converted to American Date format?