Forum Discussion
Solved
Text yy to date yyyy
Hello guys, I have a the last two digits of the year and is in text format how can I make it 2020,2019 and in date format?
Kalachuchi , Aumming you have year values like 19
a new column in date format
Date([Year]1,1)
or
date(2000+[Year],1,1)
in yyyy format
year(Date([Year]1,1))
or
year(date(2000+[Year],1,1))
1 Reply
Kalachuchi , Aumming you have year values like 19
a new column in date format
Date([Year]1,1)
or
date(2000+[Year],1,1)
in yyyy format
year(Date([Year]1,1))
or
year(date(2000+[Year],1,1))