Forum Discussion

robofski's avatar
robofski
Icon for Resolver II rankResolver II
9 years ago

Date Formats

I'm in the UK   I have a field that I'm importing as YYYYMMDD.    I'm writting reports that are mainly used in the US so I created a date field using:   DATEVALUE(mid(vw_PowerBI_Analysis[OrderC...
Need Help
robofski's avatar
robofski
Icon for Resolver II rankResolver II
9 years ago

kcantorThanks for the pointers.

 

I've managed to get my yyyymmdd into text that looks like a US date using some M

(Text.Combine({Text.Range(Text.From([OrderCreateDate]),4,2),Text.Range(Text.From([OrderCreateDate]),6,2),Text.Range(Text.From([OrderCreateDate]),0,4)},"/"))

However, changing to a date using the English US Locale as per your suggestion, changes it back to UK format:

 

Frustrating!