Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How do i turn a date in a column in airtable into a year in another column

Topic Labels: Dates & Timezones
336 1
cancel
Showing results for 
Search instead for 
Did you mean: 

how do i turn a date in a column in airtable into a year in another column

Example: I have a date: 3/28/2018 in one column. And I want a new column to read: 2018.

1 Reply 1

You would use this formula:

YEAR({Date Field})

You can find the full list of Date & Time functions on this page: