Gallery
Kuovonne's Guide to Airtable
Share
Explore
Kuovonne's Guide to Airtable
Data Type Conversion in Formulas

Data type conversions with Dates

Thank Kuovonne for creating this content!

Converting date and date/time fields to text

When converting a date/time field to text, you will get an ISO 8601 text string, not a date/time designed for humans to read. If you want a pretty date/time, use a formula function to convert it to text
DATETIME_FORMAT() for most conversions to text
DATESTR() for quick dates in YYYY-MM-DD format
TIMESTR() for quick times in HH:mm:ss format
I recommend using DATETIME_FORMAT() with SET_TIMEZONE() or the result will be in GMT time.
You can also set the language for months and days of the week by using SET_LOCALE().

Converting text and numbers to dates

Use DATETIME_PARSE() to convert text and numbers to dates.

Converting dates to numbers

YEAR({date})
MONTH({date})
DAY({date})
HOUR({dateTime})
MINUTE({dateTime})
SECOND({dateTime})
WEEKDAY({date})
WEEKNUM({date})
VALUE( DATETIME_FORMAT( {date}, "x"))
Thank Kuovonne for creating this content!

Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.