Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.
How can I display a date in the European date format of day-month-year?
In order to display a date in this special format, you'll need to create a new field whose job is only to display the date.
To do so, add a field to the table containing your existing date field and make its type "formula - text". (Don't know how to add a field? Please read: https://www.quickbase.com/help/adding_a_field.html)
Once you create the field, open its properties page by clicking the field's name. Enter the following in the formula box:
Right("0" & Day([your date field]), 2)& "-" & Right("0" & Month([your date field]), 2) & "-" & Year([your date field])
Replace the text "your date field" with the name of the table's date field.
QuickBase now takes the value from the date field you specified and displays it in your new formula field in European format. Add this new field to whatever views you wish. (For more on creating views, please read: https://www.quickbase.com/help/creating_a_new_view_from_scratch.html)
You can read more about formulas at: https://www.quickbase.com/help/using_formulas_in_quickbase.html
Browse by Category
Knowledge Base Categories
- Accounts (31)
- Application (57)
- E-Mail (7)
- Fields (38)
- Forms (18)
- Formulas (18)
- General (72)
- Other Product (7)
- Pages (1)
- Product (5)
- Reports (14)
- Roles (4)
- Search (1)
- Tables (5)