Pulling pieces of information from one field to another

341 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I currently have a 'Date' field that shows year, month and date. I am trying to create a new 'Year' field that is just for the year. Is it possible to create a formula or automation that allows for my new 'Year' field to automatically pull the year from my date field?

1 Reply 1
Community Manager
Community Manager

Airtable has a lot of built in features in formula to make this easy.


Year({your date field})

will give you just they year.