Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 17, 2019 01:50 PM
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.
Solved! Go to Solution.
Oct 18, 2019 08:59 AM
Oct 17, 2019 02:27 PM
This should do it (replace Date
with the name of the field that has the person’s career start date):
DATEADD(Date, 35, "years")
Oct 18, 2019 08:05 AM
Thanks Justin! is it possible to just get the year returned rather than the day/month and time stamp?
Oct 18, 2019 08:13 AM
DATETIME_FORMAT(
DATEADD(Date, 35, "years"),
YYYY
)
Oct 18, 2019 08:53 AM
Or wrap the YEAR function around the rest:
YEAR(DATEADD(Date, 35, "years"))
Oct 18, 2019 08:59 AM
Hi Justin that worked thanks!