topic Re: Convert date to year in QlikView

Convert date to year

Fri, 20 Jul 2012 18:28:56 GMT

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 — Fri, 20 Jul 2012 18:42:39 GMT

Hi,

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

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

Hope it helps

Fri, 20 Jul 2012 19:02:12 GMT

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

MayilVahanan — Fri, 20 Jul 2012 19:07:26 GMT

HI,

Try like this,

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

Hope it helps

CELAMBARASAN — Fri, 20 Jul 2012 19:32:06 GMT

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

brenner_martina — Mon, 23 Jul 2012 08:28:51 GMT

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