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.
Regards.

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

     

4 Replies

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