Age Field

[#1]

Hi.

I have to field, 1. Employee Number and 2. Date of Birth. I need third field of age of each employee from today.

Calculation = Today - Employee (Date of birth). I am trying but it not comming correct.

Please find the attached qvw for data reference.

Regards,

Balachandra

[alexandros17]

There exists a function AGE .... in date and time functions ...

[kaushiknsolanki]

Hi,

     Have a look at the attachement.

Regards,

Kaushik Solanki

[#4]

Try below.

age(Today(),Date(Date#(Field,'YYYYMM')))

[#5]

thanks for reply, how we can do the same in edit script.

regards,

Balachandra