Supported DATETIME_FORMAT format specifiers in Airtable

Last updated: August 7, 2026

Plan Availability

All plan types

Permissions

  • Owner / Creator - Can add, delete, duplicate, rename, and customize fields

  • Editors - Sort, filter, group, hide, and copy field URL

  • Commenters / Read-only - Copy field URL

Platform(s)

Web/Browser, Mac app, and Windows app (with some additional limited support on mobile)

Common formatting examples

  • ISO 8601 - ISO 8601 represents date and time in the year-month-day-hour-minutes-seconds-milliseconds format.

    • For example, 2025-12-31 15:00:00.000, represents the 10th of July 2020 at 3 p.m. It’s important to note that there is no time zone offset specified and the time is generally assumed to be in UTC format.

      • DATETIME_FORMAT({Insert Date Field Name}, "YYYY-MM-DD HH:mm:ss.SSS")

  • American datetimes - Date and time notation in the United States formats the date in month–day–year format:

    • December 31 2025

      • DATETIME_FORMAT({Insert Date Field Name}, "MMMM D YYYY")

    • 12/31/25

      • DATETIME_FORMAT({Insert Date Field Name}, "M D YY")

    • 12/31/2025

      • DATETIME_FORMAT({Insert Date Field Name}, "M/D/YYYY")

  • UK datetimes - Date and time notation in the United Kingdom formats the date in day–month–year format:

    • 31 December 2025

      • DATETIME_FORMAT({Insert Date Field Name}, "D MMMM YYYY")

    • 31/12/25

      • DATETIME_FORMAT({Insert Date Field Name}, "D M YY")

    • 31/12/2025

      • DATETIME_FORMAT({Insert Date Field Name}, "D/M/YYYY")

Determining date starts, ends, or ranges

Sometimes you might need to represent a date field as a range, such as the beginning and end of a specific week. You can achieve this by combining DATETIME_FORMAT with DATEADD to pinpoint the start (Monday) and end (Friday) of the week based on your date.

  1. Beginning of the Week (Monday)

    "Week of " & DATETIME_FORMAT(DATEADD({Date},1-DATETIME_FORMAT({Date},'E'),'day'),'ll')

  2. End of the Week (Friday)

    "Week of " & DATETIME_FORMAT(DATEADD({Date}, 7 - DATETIME_FORMAT({Date}, 'E'), 'days'), 'll')

  3. Combining the start and end of a week to capture a full week range

    "Week of " & DATETIME_FORMAT(DATEADD({Date},1-DATETIME_FORMAT({Date},'E'),'day'),'ll') & " - " & DATETIME_FORMAT(DATEADD({Date}, 7 - DATETIME_FORMAT({Date}, 'E'), 'days'), 'll')