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

[Ryan_Durkin]

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]

You would use this formula:

YEAR({Date Field})

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

Airtable Support

Formula field reference

Formulas may involve functions, numeric operations, logical operations, and text operations that operate on fields. For an overview of formula fields, please refer to the Guide to Formula, Lookup, ...