Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Pulling pieces of information from one field to another

718 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.