Discussions

  • 1.  Date Field format

    Posted 07-20-2018 10:06
    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?


  • 2.  RE: Date Field format

    Posted 07-20-2018 10:19
    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


  • 3.  RE: Date Field format

    Posted 08-10-2020 13:37
    Hello, Thank you for the solution above.

    Is there a way to do this without dropping leading zeroes for single digit months and days of the month?

    ------------------------------
    Audrey
    ------------------------------