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
I'm sorry, I pasted exactly and got an error about mismatched parenthesis. From what I could tell, another ")" should be added at the very end, but I'm still getting the same error.