Hi,
Being European but from Nordics, I want to have our dates as d.m.yyyy. This is not a built-in format in Airtable. I have therefore used DATETIME_FORMAT(SET_TIMEZONE(date, 'Finland/Helsinki'), 'D.M.YYYY') in some places where user friendliness is more important than elsewhere.
The problem is, dates formatted this way do not sort correctly in an interface. Here is an example image of that:'
Is this a bug in Airtable, or am I doing something wrong?
TIA,
Björn