Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.
Can you provide me with the exact formula to change a date format to YYYY-MM-DD?
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.