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 w...
Forum Discussion
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())
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())
Thank you Ken! Is there by chance an addition that I can make to the formula to change the font color to red if the number it generates is less than 90?