Skip to Content
0
Former Member
Apr 22, 2014 at 12:08 AM

Age calculation formula

309 Views

Hi All,

I'm calculating Age as a Formula in Bex Query Designer. My formula is (Current Date - Date of Birth) / 365.

For the above formula i'm getting the age as needed. But there is a issue when Date of Birth is blank (00.00.0000).

In such a case how do i handle it?

Regards,

DTD

Attachments

Capture.PNG (6.3 kB)