Creating a date field that just displays month and day

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I'm trying to create a date field that only displays the month and day of a date field -- i don't want the year considered. 

I've been able to do it as a formula - text field, but it doesn't sort correctly because it's text. (e.g. 1/1, 1/11, 1/25, 1/30, 1/5)

Month([Hire Date])&"/"&Day([Hire Date])

Photo of Jared Leavitt

Jared Leavitt

  • 10 Points

Posted 3 years ago

  • 0
  • 1
Try this

Right("0" & ToText(Month([Hire Date])),2) & "/" & Right("0" & toText(Day([Hire Date])),2)

That should show, for example March  the 5th as 03/05 and March 15th as 03/15