How to calculate age in between the dates?

[#1]

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]

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

Calculate Age in Qlikview

Regards,

Nadeem

[jagadeesh_diamo]

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]

Use the Age() function.