Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to code for service year milestones in 2020

Status
Not open for further replies.

deborahyr63

Technical User
May 4, 2018
1
US
I'm trying to set criteria to report on employees who have reached 5,10,15,20,25,30,35,40, 45+ years of service in 2020.
Fields: Service date, Length of Service , Service Year, Service Month, Employee ID
my initial thouight was to create a field rounding the Length of Service to whole number, i.e. 14.56 = 15; then filtering for the increments listed
But I run into the issue of those that have a January service date and Length of Service = 14.56. They won't actually hit the 15 yr milestone until January 2021. How do I exclude them? Other than manually doing it by service year... Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top