Jump to content

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

Recommended Posts

Posted

I have an employee file. i have a DATE OF HIRE field and a CURRENT YEAR field. I want the Current Year field to show what year of employment the employee is in. so, if it's between the Date of hire and a year from the date of hire , then it should say 1 in the Current Year box. Once today's date = the date of hire + 1 year, then the Current Year field should change to say 2., and keep counting every year thereafter. How do I do this? Thanks smile.gif

Posted

This is essentially an "age" type calculation, except that birthdate will be the date of hire. There are some examples of this in my file under the HandyBits post in the Samples section of this forum. Go towards the end of the post to get the latest version.

This topic is 7949 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
×
×
  • Create New...

Important Information

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