Airtable Date Formulas with Examples and Scenarios

Building on my previous overview of Airtable datetime fields, this guide dives into date formulas that make tracking dates and times more meaningful and dynamic within Airtable.

Unit Specifier

Unit specifiers allow precise control over date and time calculations. For example, to add 4 weeks from today, use:

DATEADD({datetimefield}, 4, 'weeks')

Getting Information About a Date or Time

Extract specific datetime details, like the busiest hour of appointments. Examples include:

• YEAR({datetime field})
• WEEKDAY({datetime field}, [Sunday or Monday])
• HOUR({datetime field})

Boolean Results

Use boolean formulas to compare dates and return 1 for true or 0 for false:

IS_AFTER({Start Date}, {Due Date})

Calculating Differences Between Dates

TONOW and FROMNOW

TONOW and FROMNOW show days to or from a date:

FROMNOW({Date})

Creating a New Date Based on an Existing Date

Use DATEADD to add or subtract time from a date field:

DATEADD({Due Date}, -2, 'weeks')

Work Days with Holidays

WORKDAY and WORKDAY_DIFF account for weekends and holidays:

WORKDAY_DIFF({Start Date}, {Due Date}, '2023-07-03, 2023-07-04')

Formatting and Parsing Dates

Use DATETIME_FORMAT and DATETIME_PARSE for flexible formatting:

• DATETIME_FORMAT({datetime field}, 'YY-MM')
• DATETIME_PARSE({TEXT DATE}, 'YYYYMMDD')

Setting Dates

SET_LOCALE & SET_TIMEZONE

Adjust date output based on locale or timezone:

DATETIME_FORMAT(SET_LOCALE(Now, 'fi'), 'LLLL')