Help

Pulling pieces of information from one field to another

269 1
cancel
Showing results for 
Search instead for 
Did you mean: 
ivy
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
Dan_Montoya
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.