Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Convert STRING to DATE format

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. Reg...
Need Help
  • Gordonlilj's avatar
    Gordonlilj
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

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

Gordonlilj's avatar
Gordonlilj
Solution Sage
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    Gordonlilj Thanks! This worked 😄