Forum Discussion

LauraDiak's avatar
LauraDiak
Qrew Trainee
5 years ago

Calculate Years of Employee between a date/time field and today

I am trying to develop a field that automatically calculates the years of employment (including months & days) using a date/time field (Date of Hire) and whatever day it is currently.   Thank you i...
Formulas and functions
DonLarson's avatar
DonLarson
Qrew Elite
5 years ago
Laura,

This is a two part projcet.

You need a Formula Duration field.   

  • Today()-[Date of Hire]

That gives you your first answer and can be used in reporting for seniority, total employment time and so on.

Then you need a Formula Text field to convert the Duration to each component of Years, Months and Days.  This you will want to put on Forms and specialty reports where no further calculations are to be performed on the data.


------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------