Forum Discussion

Johanna189's avatar
Johanna189
New Member
8 years ago
Solved

Unable to format dates correctly (UK Format)

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's avatar
    Johanna189
    8 years ago

    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. 

4 Replies

  • Johanna189's avatar
    Johanna189
    New Member
    8 years ago

    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's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi

     

    Please select English ( UK) for UK format dates.

     

     

    Thanks
    Raj

    • Johanna189's avatar
      Johanna189
      New Member
      8 years ago

      Hi,

       

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

       

      Thanks.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

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

         

        Thanks
        Raj