Date picker day filter

o_0_Gus · 01-29-2020 05:36 AM

Hi guys… i need to filter the “deck view”
i have in my spreadsheet a column “purchase day” and y need to filter for example “today”, 7 days before, etc"

can you help me where can i start?

thanks for your help

Kirk_Masden

So, I think the following should work:

[Date] > (TODAY() - 6)

That would be 7 or more days ago. [Date] is just a column name I made up. Please insert your column name between [ and ].

Kirk_Masden

Oops! I think my expression would be 5 days ago or more recent. Sorry.

Steve

To filter a deck view, you’ll need to use a slice:

Kirk_Masden

Yes. And I hope the expression I offered, or one like it, will work to do the filtering in that slice.