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")
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"))
Hi Justin that worked thanks!
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.