Calculating Age

[#1]

Hi:

     I need to calculate the age based on the DOB (format: YYYY-MM-DD) that I pull out from my DB. FieldName "MBR_DOB". Any ideas will be greatly appreciate.

Thanks

[alexandros17]

There is a date and time funcition AGE

[#3 · Accepted solution]

Hi,

well you can try an expression like that:

Year(Today()) - Num(Left(MBR_DOB,4))

Hope it helps

regards

Giampiero

[#4]

Thanks Giampiero:

     Work perfectly. Thanks a lot.

Best Regards

CyberDan

[#5]

Hi,

Glad to helped you.

Honestly, I think Alexandros solution is better than mine.

Try this way:

Age(Today(),MBR_DOB)

It should work.

Best regards

Giampiero

[#6]

     Both options work fine. Thanks Alexandros for your help

Thanks for your time.

CyberDan