Date Difference; Employee Hire Date and Now; Thanks so Much!

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

I have a date control on my employee form that shows the date the employee
hired in on.
I need to know how much time has elapsed since; i.e. it has been 1 year and
blank days since employee started.
if not a year, then how many days, else if over a year , then year(s) and
days...
below is the control name
Hire Date

Dave
 
Thought of something else:
I also have a rehire date control if the employee is re-hired, if the
hiredate is nul. ie.e no date , then use the rehire date as starting point
instead...
soemthing like the below, I dont know, dates are hard for me!

(If Not IsDate [Hire Date] then [rehire]
 
Back
Top