Skip to main content
Question

Need Help with Annual Date Formula

  • August 10, 2017
  • 0 replies
  • 15 views
I am trying to create a formula that references a date of birth field (Date), and acts as a countdown until that date occurs again next. For instance, if someone has a Date of Birth of 06-09-1983, I want to know how many days until 06-09 occurs again.
      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • August 24, 2017
      Make a formula duration field and use the following:


      var number Age=(Year(Today())-Year([DOB])-1)
      +If(Month(Today())>Month([DOB]),1,0)
      +If(Month(Today())=Month([DOB]) and Day(Today())>=Day([DOB]),1,0);

      var date Birthday=AdjustYear([DOB], $Age+1);

      $Birthday-Today()



      You are basically finding the age, finding the next birthday, and then finding the difference (duration) between the birthday and today.



      (Yes I'm getting old)
      Terms & ConditionsAccessibility statement