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

Ryan_Durkin · ‎Mar 31, 2021

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.

ScottWorld · ‎Mar 31, 2021

You would use this formula:

YEAR({Date Field})

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

Update a column's value when another column's valu...