Forum Discussion
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...
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!
I don't know why it is doing that. check here and see what they say: http://www.excelguru.ca/forums/forum.php
Let me know, though, in case I have this issue in the future.