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  :  61...
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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper 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.