How can I change a date/time field to display as "7/1 2pm"?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
If possible I'd prefer:

  • "Today" if date is today
  • "7/1" instead of "07/01"
  • "2pm" instead of "2:00pm" for on-the-hour times
but I understand if that's too complicated.

Thank you!!
Photo of Amber


  • 590 Points 500 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
Some options include using a formula text field to interpret the value and use conversions to numbers and text to get your goal.  Warning: this will most likely be a nasty formula.
Let me see if something like this works...
ToMonth([Date / Time Field])&"/"&ToDay([Date / Time Field])&" "&       
//The time part gets weird, and might be best leaving as is
ToText(ToTimeOfDay([Date / Time Field]))