
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 15, 2022 10:09 AM
I have a date field that imports like this:
2021-09-13 00:00
I need to extract the year and month and day from there … in different columns. Is there an automation for this?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 15, 2022 10:53 AM
This can be done using three formula fields, all with very similar formulas. For the year, wrap the YEAR()
function around a reference to that field. If your date field is named {Source Date}
, it would look like this (with an extra IF()
to prevent errors):
IF({Source Date}, YEAR({Source Date}))
This takes advantage of the fact that all of Airtable’s date functions can auto-parse certain formats of date strings.
There are also MONTH()
and DAY()
functions to extract the month and day, respectively.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 15, 2022 10:53 AM
This can be done using three formula fields, all with very similar formulas. For the year, wrap the YEAR()
function around a reference to that field. If your date field is named {Source Date}
, it would look like this (with an extra IF()
to prevent errors):
IF({Source Date}, YEAR({Source Date}))
This takes advantage of the fact that all of Airtable’s date functions can auto-parse certain formats of date strings.
There are also MONTH()
and DAY()
functions to extract the month and day, respectively.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 15, 2022 12:40 PM
Thanks - it worked great!
