Add Year (if Not Current) to MM/DD
How would I change the formula to display the year IF it is not the current year? var text MM = Right(ToText(Month([Date])),2); var text DD = Left(ToText(Day([Date])),2); If(IsNull([Date]), "...
Forum Discussion
No Problem
var text MM = Right(ToText(Month([Date])),2);
var text DD = Left(ToText(Day([Date])),2);
var text YYYY = IF(Year([Date]) = Year(Today()), ToText(Year([Date]));
If(IsNull([Date]), "",
List("/", $MM, $DD, $YYYY)
var text MM = Right(ToText(Month([Date])),2);
var text DD = Left(ToText(Day([Date])),2);
var text YYYY = IF(Year([Date]) = Year(Today()), ToText(Year([Date]));
If(IsNull([Date]), "",
List("/", $MM, $DD, $YYYY)