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.
How do i turn a date in a column in airtable into a year in another column
+35You would use this formula:
YEAR({Date Field})
You can find the full list of Date & Time functions on this page:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.