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". (To learn more, please see our Add a New Field help topic.)
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. (To learn more, please see our Create a New Report from Scratch help topic.)
To learn more about formulas in general, please see our Using Formulas in QuickBase help topic.
Browse by Category
Knowledge Base Categories
- Accounts (29)
- Application (54)
- E-Mail (7)
- Fields (40)
- Forms (19)
- Formulas (19)
- General (65)
- Other Product (7)
- Pages (1)
- Product (4)
- Reports (15)
- Roles (4)
- Search (1)
- Tables (5)