Calculate age from Date of birth in Design studio 1.6

[vishal_p3]

Hello Experts,

Please let me know how to calculate Age in years from the date of birth field coming from BEx. And on top of it I have generate a column chart against age groups (0-20, 21-40, 41-60, 61-80).

Please assist.

Thanks,

Vishal P

[TammyPowlas]

Hi - I would calculate the ages back in the BEx query.

You can also use Analysis Office to generate the age groups, depending on your BW version and Analysis Office version