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
Calculate the years worked based on career start date
Best answer by Lisa_Gervais
Or wrap the YEAR function around the rest:
YEAR(DATEADD(Date, 35, "years"))Hi Justin that worked thanks!
+21This 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!
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.