Date Field format

  • 1
  • 1
  • Question
  • Updated 4 months ago
  • Answered
  • (Edited)
Hi, 
  • QuickBase is supporting date format as mm-dd-yyyy, is it possible to get date field as mm/dd/yyyy?
  • suppose the user enters random text say "jvbsdv" in the date field in the form, the application should prompt user to enter valid data (or) the date field should be cleared. is their any way to achieve this in the Quickbase?
Photo of Vivek Vishwanath

Vivek Vishwanath

  • 474 Points 250 badge 2x thumb

Posted 4 months ago

  • 1
  • 1
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,756 Points 5k badge 2x thumb
Hi Vivek,

You need to create a formula text field for this purpose.

ToText(Month([Your Date Field]))&"/"&ToText(Day([Your Date Field]))&"/"&ToText(Year([Your Date Field]))

Thanks,
Gaurav
(Edited)