Display only current year's data

I have:

  • a collection, with created_at (YYYY-MM-DD HH:MM:SS) column.
  • a global variable on WeWeb “all_years_toggle” (boolean)

And I want to display the data in the collection as lists.

  • Displaying only data which is created this year when “all_years_toggle” is false
  • Display all data when “all_years_toggle” is true, regardless the “created_at” date

How do I accomplish this by using formula?
Thanks in advance.

Hi @Takako :wave:

Just made this short video for you: Filter dates — Tella

Does it help?

1 Like

Thanks a lot @Joyce ,
Yes this is what I was looking for.
I don’t know why I didn’t notice the filter.

Thanks again.

1 Like