MENU
    Date field type
    • 22 Jan 2025
    • 2 Minutes to read
    • Dark
    • PDF

    Date field type

    • Dark
    • PDF

    Article summary

    Plan availability

    All plan types 

    Platform(s)

    Web/Browser, Mac app, and Windows app

    Related reading

    The date field allows you to enter dates and times into your Airtable records. This article covers using date fields to streamline your team's and organization's work. 

    Adding date fields in Airtable

    Adding date fields

    NOTE

    As a default, newly created date fields attempt to use your browser's local language when selecting the local format for dates. To update the default format, you will need to change your browser's language settings.

    1. Visit your Airtable homepage.

    2. Create or open your preferred base.

    3. Add or edit a field.

    4. Search for and select Date.

    5. Click the icon under the “Date format” section and select your preferred format. Options include Local, Friendly, US, European, and ISO.

    6. There are some additional settings to consider as well:

      1. Include time - Toggle this button ON/OFF to show or hide time in the date field. When toggled on, click the icon under the “Time format” section and select your preferred format (12 hour or 24 hour).

      2. Use the same time zone for all collaborators - Toggle this button ON/OFF to lock down time parity for collaborators who are working across multiple time zones. Note that the “Include time” option must be toggle on in order for you to access the “Use the same time zone for all collaborators” setting.

      3. Display time zone - Opt to display the time zone by toggling ON/OFF the “Display time zone” button.

      4. Default option - Lastly, you may choose to toggle on the “Default to current date” option. This means that when a record is created, the date field will automatically default to the date (and time, if enabled) when the record is created.

    7. Click Create field.

    Adding dates into date fields

    NOTE

    Dates before 1/1/0000 aren’t supported in date fields.

    1. Visit your Airtable homepage.

    2. Open your preferred base.

    3. Double-click the blank record you want to update and select your preferred date.

      1. Alternatively, you can enter your preferred date by typing it (11/15/23).

    FAQs

    What format do date field values appear in when used in automations?

    Regardless of the format chosen in the date field’s settings, dates in automations will appear in ISO formatting that is in parity with how Airtable interacts with the date(time) on the backend. If formatting is very important to the way an automation is displayed in the output of your automation, then we suggest creating one or more formula fields to control for this on the front end (what is feeding the automation the value) and/or the end result. Check out the DATETIME_FORMAT() formula article for some ideas.


    Was this article helpful?