Having trouble converting whole number to date

[cdawidow]

Hi guys,  for some reason my files consist of order dates in the form of a whole number such as this  200910  If converted correctly, it should read as 2020 - 09 - 10 or September 10th 2020.

The problem is I have trouble converting this into a date.  Any suggestions of how to do so easily in dax?

[amitchandak]

@cdawidow , My advice would be covert it into date column like

Column 

Date = date(quotient([order dates],100), Mod([order dates],100),1)  //whole number

Date =  date(left([order dates],2), right([order dates],2),1) // text

you can use the format from the column menu. Or format function to get desired format

[Greg_Deckler]

@cdawidow - Try:

Date Column =
  MID([Column],3,2) & "/" & RIGHT([Column],2) & "/" & LEFT([Column],2)

then convert that to a date.