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
DD.MM.YYYY predefined format required
Best answer by Jason11
Hi @Cagatay_Altunsoy,
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!
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.
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.
I should clarify: I, too, am working in European format (DDMMYYYY).
+20Hi @Cagatay_Altunsoy,
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!
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.