Forum Discussion
Solved
Century date format to current date format
Hi My date format centure date(7 numbers) example:1170228 left to right:first number is centure1 for 20,0 for 19 then two digit is years mean 197 mean 2017 years then 02 mean MM then 28 is DD ...
Aruna_ln,
You can change the data type of the Date column to Date.
Regards,
Lydia
Aruna_ln,
Create the following columns in your table.
Column = IF(LEFT(Table[Column1],1)="0","19","20")
Date = Table[Column]&MID(Table[Column1],2,2) &"/"& MID(Table[Column1],4,2) &"/" &RIGHT(Table[Column1],2)
Regards,
Lydia
