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...
kcantorMany thanks.
Looking at how that works it would appear it won't accept yyyymmdd as the input so I'll have to transform the column first to a dd/mm/yyyy or am I missing something?
In modeling - check to see if indeed the column is shown as "text". It probably is. Change that to 'Date'. Then in the Date/Time format selector you will be able to select the format you seek.