AmberPollardQrew Assistant Captain8 years agoAdd Year (if Not Current) to MM/DDHow 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]), "...Show More
QuickBaseCoachDQrew Captain8 years agoOh and to sort just sort on your date field even though it may not be used as a column on the report.
Related ContentPipeline - Add Year from Record Created to a fieldYear Formula helpChart - Year over Year for Current MonthConverting Date From mm-dd-yyyy to dd/mm/yyyyCreate a formula duration over 5 years