Forum Discussion

Frequent Visitor

6 years ago

Future date

Need to calculate when someone will reach age 55 and 60 from their birthdate. Thank you,

Community Champion

6 years ago

Perhaps:

ICantDrive55 = 
  VAR __Birthday = [Birthday]
RETURN
  DATE(
    YEAR(__Birthday) + 55,
    MONTH(__Birthday),
    DAY(__Birthday)
  )