Reply to comment

If you'd like to change the default date format to YYYY-MM-DD throughout your account or app, see the instructions in this help topic: http://www.quickbase.com/user-assistance/#about_localizing_dates_numbers...

If your account admin or app admin has set the default date to something other than YYYY-MM-DD, and you'd like to display that format for a single field, follow the instructions below:

Create a Formula-Text field and set the formula to:

Year([YourDate]) & "-" & Right("0" & Month([YourDate]), 2) & "-" & Right("0" & Day([YourDate]), 2)

This formula assumes your Date field in QuickBase is called "YourDate". Substitute your Date field name for "YourDate" in the formula above to show that field in YYYY-MM-DD format.

Reply

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit