I have a list of projects with dates. I would like to filter the items shown by their year, e.g. 2019, 2020… I assume the best way is to create a new column in the data sheet. However, I cannot work out how to extract the year. The If, then, else function should work since it recognizes dates but I…

Create a math column in the glide data editor and use the year(date) formula. You don’t have to do any of this in the google sheet.

How can I extract the year from a date using a data column?

Simon_Hill November 30, 2020, 6:46am 5

Thanks so much Jeff… it worked like a dream!

2 Likes

Topic		Replies	Views
Column GetYear() Ask for Help	3	317	June 1, 2020
Filter Dates that are equal to This Month Ask for Help	7	1608	March 7, 2022
ARRAYFORMULA to calculate DATE that is one year later than the given date? Ask for Help	4	606	February 9, 2021
How can I extract date from text column? Ask for Help	5	419	May 22, 2023
Google sheets date functions in Glide Ask for Help	3	348	December 4, 2020