Skip to main content
Question

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

  • December 30, 2020
  • 0 replies
  • 200 views
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 in advance!

------------------------------
Laura Diak
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+15
  • DonLarson
  • Quickbase Alumni
  • December 30, 2020
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
------------------------------
  • BlakeHarrison
  • Quickbase Alumni
  • December 30, 2020
Unfortunately, there isn't a numeric field type that would produce Years, Months, and Days. You would probably need to either do 3 individual numeric formulas OR a single Text formula.


------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Terms & ConditionsAccessibility statement