Calculating age within date range
661537Nov 6 2008 — edited Nov 6 2008Hi All,
I need to calculate age of the person who will complete 20 years of age whose birthday falls within the given date range. There is a field called birthdate and there are 2 more date fields (date1 and date2) as input parameters.
For Eg,
Birthdate : 10/08/1988
Date1 as input parametr : 10/01/2008
Date2 as input parametrs : 10/10/2008
I need to find:
1) the Age of the employee (ie. 20 should be displayed)
2) the date when the employee will complete 20 years ( the query should display 10/08/2008. Hard code value not allowed..need to dynamically calculate the value)
Any help will be appreciated.
Thanks in advance