Working with dates

This article covers how to use the DATETIME_FORMAT function to streamline your team's and organization's work. Note If you are looking to parse out a datetime from a string, then use the DATETIME_PARSE() function. Learn more here . DAT...

In this article, we’ll take a look at functions that will help you work with dates and times. 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 time field....

Note "Payment Received" and "Invoice Billed" are the exact names of our two date fields in the example below. You'll need to apply the examples below to the fields in your particular Airtable instance. If your base contains date strings...

This article covers using the DATETIME_DIFF() to calculate the difference between two different date times in specified units to streamline your team's and organization's work. Introduction DATETIME_DIFF() in Airtable overview DATETIME_DIFF(...

Learn how various format specifiers can be used to format a date as a string in Airtable. Introduction Understanding the DATETIME_FORMAT function Understanding the DATETIME_FORMAT The DATETIME_FORMAT function will allow you to reforma...

This article covers the DATETIME_PARSE() function—taking date & time information and interpreting it as structured values that Airtable can use to streamline your team's and organization's work. Note If you are looking to format a date,...