Supported DATETIME_FORMAT format specifiers in Airtable

Last updated: October 19, 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)

Check out our this article to learn more about using the DATETIME_FORMAT function in formulas.
Check out our Timezones and locales article to learn more about using the DATETIME_FORMAT function with timezones.

Supported format specifiers

Airtable uses Moment.js tokens for date parsing and formatting, so DATETIME_FORMAT accepts the format specifiers below. Specifiers are case-sensitive, and you can combine them freely with separators such as slashes, hyphens, and spaces.

The specifiers "w" and "W" behave differently. "W" is the ISO week of the year, while "w" is the locale week of the year (Gregorian calendar in GMT). For example, 2/11/21 falls in the 6th ISO week and the 7th Gregorian week.

Format specifier	Description	Example(s)
M	Month of the year, cardinal nos. 1-12	1 2 ... 11 12
Mo	Month of the year, ordinal nos. 1st-12th	1st 2nd ... 11th 12th
MM	Month of the year, cardinal nos. 01-12	01 02 ... 11 12
MMM	Month name, 3-letter abbreviation	Jan Feb ... Nov Dec
MMMM	Full month name	January ... December
Q	Quarter of the year, cardinal nos. 1-4	1 2 3 4
Qo	Quarter of the year, ordinal nos. 1st-4th	1st 2nd 3rd 4th
D	Day of the month, cardinal nos. 1-31	1 2 ... 30 31
Do	Day of the month, ordinal nos. 1st-31st	1st 2nd ... 30th 31st
DD	Day of the month, cardinal nos. 01-31	01 02 ... 30 31
DDD	Day of the year, cardinal nos. 1-365	1 2 ... 364 365
DDDo	Day of the year, ordinal nos. 1st-365th	1st 2nd ... 364th 365th
DDDD	Day of the year, cardinal nos. 001-365	001 002 ... 364 365
d	Day of the week, cardinal nos. 0-6	0 1 ... 5 6
do	Day of the week, ordinal nos. 0th-6th	0th 1st ... 5th 6th
dd	Day of the week, 2-letter abbreviation	Su Mo ... Fr Sa
ddd	Day of the week, 3-letter abbreviation	Sun Mon ... Fri Sat
dddd	Full day of the week	Sunday ... Saturday
e	Day of the week (locale)	0 1 ... 5 6
E	Day of the week (ISO)	1 2 ... 6 7
w	Week of the year, cardinal nos. 1-53	1 2 ... 52 53
wo	Week of the year, ordinal nos. 1st-53rd	1st 2nd ... 52nd 53rd
ww	Week of the year, cardinal nos. 01-53	01 02 ... 52 53
W	Week of the year (ISO), cardinal nos. 1-53	1 2 ... 52 53
Wo	Week of the year (ISO), ordinal nos. 1st-53rd	1st 2nd ... 52nd 53rd
WW	Week of the year (ISO), cardinal nos. 01-53	01 02 ... 52 53
YY	Year, last 2 digits	00 01 ... 98 99
YYYY	Full year	2000 2001 ... 2098 2099
gg	Week year, last 2 digits	00 01 ... 98 99
gggg	Full week year	2000 2001 ... 2098 2099
GG	Week year (ISO), last 2 digits	00 01 ... 98 99
GGGG	Full week year (ISO)	2000 2001 ... 2098 2099
A	AM/PM (uppercase)	AM PM
a	am/pm (lowercase)	am pm
H	Hour, 24-hour clock, 0-23	0 1 ... 22 23
HH	Hour, 24-hour clock, 00-23	00 01 ... 22 23
h	Hour, 12-hour clock, 1-12	1 2 ... 11 12
hh	Hour, 12-hour clock, 01-12	01 02 ... 11 12
m	Minute	0 1 ... 58 59
mm	Minute (zero-padded)	00 01 ... 58 59
s	Second	0 1 ... 58 59
ss	Second (zero-padded)	00 01 ... 58 59
S	Fractional second (1 digit)	0 1 ... 8 9
SS	Fractional second (2 digits)	00 01 ... 98 99
SSS	Fractional second (3 digits)	000 001 ... 998 999
SSSS...SSSSSSSSS	Fractional second (4-9 digits)	000[0..] ... 999[0..]
Z	Timezone offset from GMT, with colons	-07:00 -06:00 ... +06:00 +07:00
ZZ	Timezone offset from GMT, without colons	-0700 -0600 ... +0600 +0700
X	Unix timestamp	1360013296
x	Unix millisecond timestamp	1360013296123
LT	Preset time format: h:mm A	6:30 PM
LTS	Preset time format: h:mm:ss A	6:30:45 PM
L	Preset date format: MM/DD/YYYY	06/08/2016
l	Preset date format: M/D/YYYY	6/8/2016
LL	Preset date format: MMMM D, YYYY	June 8, 2016
ll	Preset date format: MMM D, YYYY	Jun 8, 2016
LLL	Preset datetime format: MMMM D, YYYY h:mm A	June 8, 2016 6:30 PM
lll	Preset datetime format: MMM D, YYYY h:mm A	Jun 8, 2016 6:30 PM
LLLL	Preset datetime format: dddd, MMMM D, YYYY h:mm A	Wednesday, June 8, 2016 6:30 PM
llll	Preset datetime format: ddd, MMM D, YYYY h:mm A	Wed, Jun 8, 2016 6:30 PM

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 December 31, 2025 at 3:00pm. There's no timezone offset specified—the time is assumed to be in UTC.
  - 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.

Beginning of the Week (Monday)

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

End of the Week (Friday)

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

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')