Unable to format dates correctly (UK Format)

[Johanna189]

Hi,

I have a column in my table to show dates which is currently data type "Text". I want to change it to a date format so that I can sort the column by date correctly.

If I change this column data type to "Date" it formats some as UK dates and some as US dates.

For example:

11/05/2018 changes to 05 November 2018 (incorrect for UK date format)

15/05/2018 changes to 15 May 2018 (correct for UK date format)

How can I get them to all show up as UK dates? I have the regional settings set to English.

Thanks!

[Johanna189 · Accepted solution]

I've managed to fix this now thank you. I had to go back into the query editor and choose " Using Locale..." on the date column and set this to UK format as well. 

[Anonymous]

Hi

Please select English ( UK) for UK format dates.

Thanks
Raj

[Johanna189]

Hi,

I do already have this set to English (UK).

Thanks.

[Anonymous]

Do you want to use FORMAT( date_column, "DD/MM/YYYY") ?

Thanks
Raj