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
Oh and to sort just sort on your date field even though it may not be used as a column on the report.