Jump to content

Calculating Years


This topic is 4384 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I hope someone will be able to help me with this calculation. I'm trying to calculate employees Lenght of Service (LOS).

Example, if an employee 1 started in 1994 and Employee 2 started in 2001. I want to calculate there total years so employee 1 would be at 17 years and employee 2 at 10 years and have it calculate each year. How do I create that formula. Any help would be greatly appreicated.

Link to comment
Share on other sites

I hope someone will be able to help me with this calculation. I'm trying to calculate employees Lenght of Service (LOS).

Example, if an employee 1 started in 1994 and Employee 2 started in 2001. I want to calculate there total years so employee 1 would be at 17 years and employee 2 at 10 years and have it calculate each year. How do I create that formula. Any help would be greatly appreicated.

Depending on how your start date is stored, you can do a couple things.

Year(Get(CurrentDate)) - Year(empStartDay) - This works if the empStartDay is a date field or a timestamp field.

Year(Get(CurrentDate)) - Year(GetasDate(empStartDay)) - This works if the empStartDay is a text field, depending on format.

Link to comment
Share on other sites

This topic is 4384 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.