Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Calculate the years worked based on career start date

Solved
Jump to Solution
1753 0
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!