Help

Re: Auto Date from another field

Solved
Jump to Solution
800 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Lost-Merovingia
7 - App Architect
7 - App Architect

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?

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

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.

Screen Shot 2022-01-15 at 10.51.40 AM

See Solution in Thread

2 Replies 2
Justin_Barrett
18 - Pluto
18 - Pluto

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.

Screen Shot 2022-01-15 at 10.51.40 AM

Lost-Merovingia
7 - App Architect
7 - App Architect

Thanks - it worked great!