Forum Discussion

AmberPollard's avatar
AmberPollard
Qrew Assistant Captain
8 years ago

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]), "...
AmberPollard's avatar
AmberPollard
Qrew Assistant Captain
8 years ago

For the record, I think you had = instead of <>. I corrected the formula and changed for two year characters below. Thank you!!!


var text MM = Right(ToText (Month([Date])),2);

var text DD = Left(ToText(Day([Date])),2);

var text YY = If(Year([Date]) <> Year(Today()), Right(ToText(Year([Date])),2));

If(IsNull([Date]), "",

List("/", $MM, $DD, $YY))