Skip to main content
Question

Date format in MM/DD/YYYY despite me changing column to DD/MM/YYYY

  • February 23, 2026
  • 1 reply
  • 8 views
CKARC
Forum|alt.badge.img+10

Hi Airtablians

I have a date column which I have set to DD/MM/YYYY . . when i try to cut or import data into it sometimes it works, sometimes it doesnt, i have realised that even though I have set the field explicitly as DD/MM/YYYY format like most of the known world, it still wants in input in MM/DD/YYYY then it represents that back in the format I want to see it i.

This is causing havoc with automations.

I am guessing that there is a central “what format is the date in this entire table/workspace in” setting but I cant find it?

 

My date settings
 

field input still wanting me to enter in 


it appears this is why i cant cut or import data in unless it is MM/DD/YYYY format (which also means all the datas in the dataset are probably wrong, but i saved in s asecond text field as backup. 

The field is linked to an interface, in case that means anythiung?

1 reply

DisraeliGears01
Forum|alt.badge.img+21

The “Local” setting is MM/DD/YYYY (Feb 24, 2026 in your screencap). I forget how “Local” is determined, it might be during account creation or go by IP, but regardless you can just use that dropdown and select “European”.

Airtable stores everything behind the scenes into a UTC datetime string ( 2026-02-24T00:00:00.000Z) and then converts it into a preferred format from there.

    Terms & ConditionsAccessibility statement