Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
Use the Age() function.