
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 14, 2020 09:33 AM
Hello,
How can I format date column as DD.MM.YYYY
It does not include in pre-defined formats.
As example predefined format for 1st of February 1985 is; 1.2.1985
What I want is; 01.02.1985
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 15, 2020 11:09 AM
While we don’t have this specific format as part of the date field, you can use a formula to transform how an entered date appears. To start, make sure your date field is formatted as European format.
Then, add a formula field to your table. In the formula field, enter this function:
IF({Date}, DATETIME_FORMAT(Date, 'DD.MM.YYYY'))
This formula will check to see if there’s a value in the date field, and if there is, it will format it like you described. When you use this in your own table, make sure to replace {Date}
with the actual name of your date field.
Here’s a short GIF showing that functionality. Hope this helps!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 15, 2020 02:29 AM
I agree with this suggestion. As someone writing a 20,000-30,000-record database of historical events, I would find the visual alignment entailed in all dates requiring 8 digits a major improvement.
Right now, as my eye runs down the date column, it is too distracted by the “hokey-pokey” effect of dates snaking in and out as D and M switch to DD and MM. I would like to be able to spot more quickly when something as important as the year changes.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 15, 2020 02:31 AM
I should clarify: I, too, am working in European format (DDMMYYYY).

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 15, 2020 11:09 AM
While we don’t have this specific format as part of the date field, you can use a formula to transform how an entered date appears. To start, make sure your date field is formatted as European format.
Then, add a formula field to your table. In the formula field, enter this function:
IF({Date}, DATETIME_FORMAT(Date, 'DD.MM.YYYY'))
This formula will check to see if there’s a value in the date field, and if there is, it will format it like you described. When you use this in your own table, make sure to replace {Date}
with the actual name of your date field.
Here’s a short GIF showing that functionality. Hope this helps!
