Convert date to year

[#1]

I have a date in the format 56321, would like to be able to convert a column in another year and month, separated, how can I do this?

[MayilVahanan]

Hi,

     Date(56321,'YYYY/MM') gives 2054/03

     or

     Date(56321,'YYYY') gives 2054 for Month, Date(56321,'MM') gives 03

Hope it helps

[#3]

Thanks, but i have a age column, for example: -54950, how do I convert to, for example, 50 years, 49 years?

[MayilVahanan]

HI,

     Try like this,

     =age(fabs(-54950),num(today())) gives 37.

     Hope it helps

[CELAMBARASAN]

Explain about age conversion with the data you provided little more breifer?

[brenner_martina · Accepted solution]

Hi,

for counting the age it is better to use this expression:

Floor(Num(Today() - DateofBirth)/365,25)

that means, 365,25 is the number of days a year with a quarter day for 29th of February and floor truncs the decimals

Greetings

Martina