Kuovonne's Guide to Airtable

Share

Explore

Kuovonne's Guide to Airtable

Data Type Conversion in Formulas

Data type conversions with Dates
Data type conversions with Dates

⁠

⁠ Tip Jar ⁠ 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! ⁠ Give Kuovonne a sandwich ⁠ Signup for Coda w/ referral link ⁠ ⁠ ⁠Buy from my Gumroad Store ⁠ ⁠ ⁠ ⁠ ⁠

⁠

⁠

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.