Aug 18, 2024 08:56 AM
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
Solved! Go to Solution.
Aug 18, 2024 10:34 AM
Hello Björn,
I think that's because the result of your formula is of type text and not date. I would suggest to use this field for display purposes only and to sort on the field "date" called in your formula.
Regards,
Pascal
Aug 18, 2024 10:34 AM
Hello Björn,
I think that's because the result of your formula is of type text and not date. I would suggest to use this field for display purposes only and to sort on the field "date" called in your formula.
Regards,
Pascal
Aug 19, 2024 02:31 AM
Hi @Pascal_Gallais- ,
Thank you. Indeed, when I checked this up with Airtable documentation, it confirms the output from a DATETIME_FORMAT is not a date, but a string. I should of course have checked this myself before asking, so apologies. I just couldn't imagine that a function for formatting dates beyond the very limited options built in the field itself would not result in a string. I'd call this a bug :).
Rgds,
Björn