topic Re: How to calculate age in between the dates? in QlikView

How to calculate age in between the dates?

Mon, 15 Dec 2014 06:23:29 GMT

Hii,

can you anyone help to calculate the age in between dates in script.

-> actually i tried this ' SET VDATE=TODAY(); in main script'

-> next calculate the age like ' ($(VDATE)-DOB) AS AGE'

Is this correct query or not.

thanks in advance,

Hita

fashid — Mon, 15 Dec 2014 06:29:54 GMT

Hi,

THIS WILL ONLY GIVE YOU A DATE AGAIN YOU WILL HAVE TO USE YEAR FUNCTIONS AND THEN CALCULATE NO OF YEARS BETWEEN THE TWO DATES.

check this discussion maybe it will help

Regards,

Nadeem

jagadeesh_diamo — Mon, 15 Dec 2014 06:37:18 GMT

Hi,

Try this

Ceil((Today()-MakeDate(DOB))/365) as Age

EX:

Ceil((Today()-MakeDate(2000,01,01))/365) as Age

Round((Today()-MakeDate(2000,01,01))/365) as Age

You can use Variable instead of makedate if more records are there.

Thanks.

MarcoWedel — Mon, 15 Dec 2014 15:44:50 GMT

Use the Age() function.