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

  • 160 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
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)
)