can dates be shown with a / and not -

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

Is it possible to show dates with a backslash and not a em dash.  for example I want to the date to read as 1/27/16 and not 1-27-16.

Photo of Cecelia

Cecelia

  • 180 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Well, there is no setting for that. So if you wanted it bad enough, you would need to create your own text formula fields to be used in View mode on forms and reports. One per Date field.

Not tested but something like

var date D = [My Date Field];

List("/",
ToText(Month($D)),
ToText(Day($D)),
Right(ToText(Year($D)),2)
)