Future date

Question

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

morsh · Answer

Perfect.&nbsp; Thank you so much!

greg_deckler · Answer

Perhaps:
&nbsp;
ICantDrive55 = 
  VAR __Birthday = [Birthday]
RETURN
  DATE(
    YEAR(__Birthday) + 55,
    MONTH(__Birthday),
    DAY(__Birthday)
  )

Forum Discussion

Future date

2 Replies

Related content

Datamart future

Looking at future orders based on date selection

Conditional Formatting Measure Highlighting Dates in Past and Future

Future Date Filtering

Relative date filtering including future dates