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 colum...
  • Johanna189's avatar
    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.