jph826
asked on
How to identify anniversaries next month?
CRV 11 - I have an anniversary report that runs on the 20th of every month showing anniversaries in the upcoming month (regardless of day) .
The December 20th report showed two employees; one with a hire date of 1/3/2011 (result was 6 yrs of service) and one with a hire date of 1/28/2013 (result was 4 yrs of service). BOTH results are short one year and should be 7 and 5. The formula I'm using is Year (currentdate) - Year({EMPLOYEE.DATE_HIRED} ). Any advice would be appreciated.
The December 20th report showed two employees; one with a hire date of 1/3/2011 (result was 6 yrs of service) and one with a hire date of 1/28/2013 (result was 4 yrs of service). BOTH results are short one year and should be 7 and 5. The formula I'm using is Year (currentdate) - Year({EMPLOYEE.DATE_HIRED}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, that worked.
"The problem with calculating age is that it is calculated as an integer, and always rounded down..."