Calculate the years worked based on career start date

I’m looking to estimate a person’s retirement date based on their career start date, this would be using the assumption that they would work 35 years following their first job.

This should do it (replace Date with the name of the field that has the person’s career start date):

DATEADD(Date, 35, "years")
1 Like

Thanks Justin! is it possible to just get the year returned rather than the day/month and time stamp?

DATETIME_FORMAT(
   DATEADD(Date, 35, "years"),
   YYYY
)
1 Like

Or wrap the YEAR function around the rest:

YEAR(DATEADD(Date, 35, "years"))
1 Like

Hi Justin that worked thanks!

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.