Skip to Content
0
Former Member
Aug 10, 2016 at 02:11 PM

Calculating age of employee based on user input in Bex query

355 Views

Hi All,

We have an reporting requirement where in user wants an option to enter the date in the variable input screen and based on that we have calculate the age of the employee.

Example: If employee EMP1 is born on 01.JAN.1990 and if the user enters the date as 01.JAN.2013 in the variable input screen at the query variable screen [ Users main requirement is to see employees ages in particular year in the past date ]

The age should show as 23 years , although as on system date it will be 26 years.

I saw there are various articles which shows how to calculate age based on system date , but not with an option of user entered date.

Looking forward for your valuable input.

Thank you.