Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Johanna189
New Member

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!

1 ACCEPTED SOLUTION
Johanna189
New Member

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. 

View solution in original post

4 REPLIES 4
Johanna189
New Member

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
Not applicable

Hi

 

Please select English ( UK) for UK format dates.

 

Date settings.PNG

 

Thanks
Raj

Hi,

 

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

 

Thanks.

Anonymous
Not applicable

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

 

Thanks
Raj

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.