Leaving Airtable? Bring your bases to Artavolo, checked record by record. See how

Date field: dates, times and time zones

Updated

A Date field holds a calendar day, and a time of day if you want one. Calendar and Timeline views place records by their date fields, and filters can find records before, after or within a span of dates.

Add a Date field

  1. Press the + after the last field and choose Date.
  2. Choose a Date format.
  3. Tick Include time if the time of day matters.
  4. Tick Default to today if new records should start with today's date.
  5. Press Create field.

The Edit field dialog for a Date field: date format, Include time, Default to today, who can edit its values and a description

Choose how dates look

  • Local follows each person's browser, so everyone sees dates written their own way.
  • Friendly (October 14, 2026), US (10/14/2026), European (14/10/2026) or ISO (2026-10-14) show the same format to everyone.
  • With a time, Time format chooses 12 hour or 24 hour.

Enter a date

  • Click the cell and pick the day from the calendar, or type it.
  • Typing understands the usual ways of writing a date: 2026-10-09, 9 October 2026, October 9, 2026.
  • A date such as 12/02/2026 is read in the field's format: 12 February with the European format, 2 December with the US format.

Time zones

A date without a time is the same calendar day for everyone, wherever they are. A date with a time is one moment, shown in each person's own time zone, so a 09:00 meeting in Berlin shows as 08:00 in London.

When the time should read the same for everyone, tick Use the same time zone (GMT) for everyone. Display time zone adds the zone after the time, so nobody has to guess.

Related field types

  • Created time and Last modified time fill themselves in. A Last modified time field can watch all fields or only the ones you pick under Changes to.
  • Time of day holds a clock time with no date.
  • Duration holds a length of time, such as 1:30.
  • A formula can work with dates: days until a deadline, a date plus two weeks, working days between two dates.

Good to know

  • Only the base's owners add or change fields. Anyone who may edit records can fill in dates.
  • On a phone, the date picker opens from the bottom of the screen without the keyboard.
  • Changing Date format changes only how dates look. The stored dates stay the same.

Related