Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

convert numeric value to date

I have data (dates )coming in 5 digit and 6 digit values. I need to convert them into dates but cant seem to get a solution for this. 

 

24th of november, 2017  :  241117

6th december, 2017  :  61217

 

Below is the data which i need to convert into date format "DD/MM/YY" or "MM/DD/YY"

 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    This calculate column works

     

    =DATE("20"&RIGHT(Table1[Date],2),MID(FORMAT(Table1[Date],"000000"),3,2),LEFT(FORMAT(Table1[Date],"000000"),2))

     

    Hope this helps.

1 Reply

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

     

    This calculate column works

     

    =DATE("20"&RIGHT(Table1[Date],2),MID(FORMAT(Table1[Date],"000000"),3,2),LEFT(FORMAT(Table1[Date],"000000"),2))

     

    Hope this helps.