AnsweredAssumed Answered

Match current month and day

Question asked by TimCranwill on Feb 18, 2015
Latest reply on Feb 18, 2015 by TimCranwill


Match current month and day


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.