1 Reply Latest reply on Feb 18, 2015 12:22 PM by TimCranwill

    Match current month and day

    TimCranwill

      Title

      Match current month and day

      Post

      More dates... I need a calculation that will compared a date fields month and day called (start date) with current date month and day. (without year) if month and day(start date) match or is past the month and day(current date) then set field to the month and day(start date) with current year, if they don't match or its before the month and day then set field  to month and day(start date) current year -365

      I hope that makes sense? basically need a date field that always keeps the (start date) month and day the same but toggle the year on its anniversary every year.

        • 1. Re: Match current month and day
          TimCranwill

          Never mind, i got it.

           

          If ( Date(Month ( Start Date );Day ( Start Date );Year(Get ( CurrentDate )))  ≤  Date(Month ( Get(CurrentDate) );Day ( Get(CurrentDate));Year(Get ( CurrentDate ))) ; Date(Month ( Start Date );Day ( Start Date );Year(Get ( CurrentDate ))) ; Date(Month ( Start Date );Day ( Start Date );Year(Get ( CurrentDate ))) -365)