Skip to main content
Question

Need Help with Annual Date Formula

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.

      • KenFirch
      • Registered
      • August 10, 2017
      For a formula duration field:

      var date thisyear = Date(Year(Today()),Month([Birth Date]),Day([Birth Date]));
      var date nextyear = Date(Year(Today()) + 1,Month([Birth Date]),Day([Birth Date]));

      If($thisyear >= Today(),
        $thisyear - Today(),
        $nextyear - Today())
      Terms & ConditionsAccessibility statement