Text yy to date yyyy

[Kalachuchi]

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?

[amitchandak · Accepted solution]

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