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)
    )

     

Gordonlilj's avatar
Gordonlilj
Solution Sage
6 years ago

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'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 😄