#Airtable dateadd formula how to
#Airtable dateadd formula plus
#Airtable dateadd formula series

You can find descriptions of how to use each of these functions in the reference table above. The most useful functions for comparing two dates in an Airtable formula are the IS_AFTER, IS_BEFORE, and IS_SAME functions. However, if you need to look them up, you can find them described on this page.

There are a few additional datetime functions available in Airtable that I have not included in the reference table above since they aren’t generally as useful. You can find a complete list of all format specifier codes here “LL” –> display date in format “ day, YYYY” (e.g. “L” –> display date in format “MM/DD/YYYY” “ZZ” –> timezone relative to GMT, not including colons (e.g. “Z” –> timezone relative to GMT, including colons (e.g. “dddd” –> “Sunday”, “Monday”, etc (full day of the week name) “ddd” –> “Sun”, “Mon”, etc (3-letter day of the week abbreviation) “dd” –> “Su”, “Mo”, etc (2-letter day of the week abbreviation) “MMMM” –> “January”, “February”, etc (full month name) “MMM” –> “Jan”, “Feb”, etc (3-letter month abbreviation) Output: A string of text that represents a date or datetime in the specified format – a character or string, with quotes, that represents a specified way to format a date or datetime (e.g. Output: A number from the range 0-6 representing the day of the week (0=Sunday, 6=Saturday)ĭATETIME_FORMAT( datetime, “format-specifier”) Output: A number from the range 0-23 representing the hour of the specified datetime (0=12am, 23=11pm) Output: The four-digit year of the input date or datetime Output: A number from the range 1-12 representing the month (1=January, 12=December) Output: A number from the range 1-31 representing the day of the month for the input date

#Airtable dateadd formula plus

Output: A duration of time written as a number plus a unit, representing the time between NOW() and the specified input date.Į.g. Output: a number (computed as the number of time “units” between date_1 and date_2) Output: date or datetime that results from adding the specified number of time units to the specified date or datetime – “units” (one of the same options as above) Output: 1 if date_1 is the same as date_2 (up to one “unit” of granularity, if “units” is included as an input) otherwise 0Īirtable also supports “seconds” and “milliseconds”, but these typically are more granular than most people will find useful – “units” is an optional third input that can be left out if desired if included, it is a unit of time written as a string with quotes (e.g. Output: 1 if date_1 is before date_2, otherwise 0 If one input is a date and the other is a datetime, then the date will be interpreted as a datetime with time 12am Output: 1 if date_1 is after date_2, otherwise 0 Inputs (2): Can be dates and/or datetimes Modification to a non-computed cell of that record Output: The datetime when the record containing

#Airtable dateadd formula series

This post contains two parts: the first part is a table that lists all of the important date & time functions that are built into Airtable, together with descriptions and instructions on how to use them, and the second part of this blog post is a series of answers to common questions about how to effectively work with dates and times in Airtable. Airtable has many built-in functions to get the dates and times of different events as well as to compute durations, add durations to dates, compare dates and times, and more.