Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Calculate the years worked based on career start date

Topic Labels: Formulas
Solved
Jump to Solution
3056 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Lisa_Gervais
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Solution

Accepted Solutions
Lisa_Gervais
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Justin that worked thanks!

See Solution in Thread

5 Replies 5

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

DATEADD(Date, 35, "years")

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
)

Or wrap the YEAR function around the rest:

YEAR(DATEADD(Date, 35, "years"))
Lisa_Gervais
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Justin that worked thanks!