Convert STRING to DATE format

[Anonymous]

Hi all ,

I have a column with STRING format values which needs to be changed into DATE format.

Eg: I want to convert string "200502" into DATE format as 2020,May,2nd.

Thanks in advance.
Regards.

[Gordonlilj]

Hi,

You could create a calculated column to extract the parts and then change it into a date.

Example:

DateColumn = 
"20" & LEFT('Table'[Date],2) & "," & 
       MID('Table'[Date],3,2) & "," & 
       RIGHT('Table'[Date],2)

[Anonymous]

@Gordonlilj Thanks!
Tried that, it is throwing an error that Text cannot be converted into Date format.
Any other workaround? 

[Gordonlilj · Accepted solution]

What do you get if you use DATE function?

Using "200502" it would look like

DateColumn = 
DATE("20" & LEFT('Table'[Date],2),
            MID('Table'[Date],3,2),
            RIGHT('Table'[Date],2)
    )

[Anonymous]

@Gordonlilj Thanks! This worked 😄