Skip to main content

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")

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?

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"))

Or wrap the YEAR function around the rest:



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

Hi Justin that worked thanks!

Reply


Terms & Conditions