UK date format setup

[David_Beaumont]

How do you set it up for everything?

[Justin_Barrett]

Meaning…what? Your question is unclear. Are you asking how to set date fields to UK date format? Or are you asking about something related to formulas? Something else entirely? “Everything” is a bit too broad.

[Elias_Gomez_Sai]

I think he wants to set up a default format for the account/workspace/base. But that is not possible, I think.

[Chris_Chapman]

Yes I’d like to be able to do the same.

Airtable defaults all the date fields to US format (MM/DD/YYYY) and it’s kind of confusing for people in other countries that use DD/MM/YYYY, especially when the day of the month is 12 or less. E.g. 3/7/2019 - I read that as 3rd July 2019, but with the US date format it’s the 7th March.

Having a simple way to set the date format would be really, really nice. I thought I was going crazy when I couldn’t find a setting to change it - it’s been pretty common practice in web apps for years to support this.

[Greg_Rochlin]

I can’t believe how primitive the Preferences are in Airtable. Not to be able to change the date format is awful. I hate US dates …

[Elias_Gomez_Sai]

You can customize the format of every date Field:

Airtable - Support

Guide to the basic field types

Unlike a spreadsheet, Airtable fields (columns) have specific "types" that allow you to store rich content in each record. For example, a table can contain records (rows) with attachments...

In fact, I think that the first option is Local format. :thinking:

[Justin_Barrett]

I believe what’s being requested is a global date format setting that applies by default to all date fields, without having to change each field’s formatting manually.

[Mark_Anson]

I’m in Australia and it still says local format is US style…

[Adrian_Horn]

Yes a default date and time would be very helpful 12 hour time is for people riding the shortbus. And month day year formats (US) are worthless. Changing for each new field takes about 4 seconds. If you’re doing one no big deal. But if you’re only doing one why use airtable in the first place.

[Elias_Gomez_Sai]

Mee too:

UK date format setup Dates and timezones

I think he wants to set up a default format for the account/workspace/base. But that is not possible, I think.

–

Adrian_Horn:

Changing for each new field takes about 4 seconds

He said this, so maybe he wants to spend those 4 seconds. I was just giving options…

Greg_Rochlin:

I hate US dates …