Working with dates

If you would like to incorporate a date (and time) type field into a formula field, the best way to format that date is using the DATETIME_FORMAT function. For more information on DATETIME_FORMAT, and other formulas, we recommend checking out the...

In this article, we’ll take a look at functions that will help you work with dates and times (“datetimes”). As you learn about these functions, feel free to try them out to practice in a formula field in one of your tables that contains a date and t...

Finding the difference between two dates can be helpful for many workflows. Using the DATETIME_DIFF() function in the example below, we'll find the difference - in days - between two dates. Note that "Payment Received" and "Invoice Billed" are the...

The DATETIME_DIFF() function will allow you to calculate the difference between two different datetimes in specified units. Each specifier has a corresponding abbreviation which will work the same as the longform version of the specifier, e.g. DATE...

The DATETIME_FORMAT function will allow you to reformat the data from the date-type field into a string of your specifications. This is written in the format of DATETIME_FORMAT(Datetime, 'format specifier') , in which the format specifier can be s...

The DATETIME_PARSE() function works by taking a date & time information - written in virtually any format - and interprets it as a structured value that Airtable can understand. For example, in a single line text field you might have this value wr...