Create slice based on date range

AppSheet AppSheet Q&A
1

Hi all,

I have a table that has a Transaction Date column and I want to create a slice that will only show values within the last 365 days. I would also be ok if it is by Month, so only the last 12 months. How would I go about doing this?

Thanks!

2

Slice filter expression could be something like

AND([Transaction Date]>=TODAY()- 365,

[Transaction Date]<TODAY()

)

Minor adjustments to equality operators may be required based on if you wish to include today in the list or not etc.