Slice: include rows if date field is within the last 90 days to upcoming 14 days

AppSheet AppSheet Q&A
1

Hi there,

I was needing a formula for a slice that includes items with an inspection due date in a date range from the last 90 days (overdue!) through the upcoming 14 days. I struggled with this and didn’t find any straightforward solutions here, so I’m sharing what I got to work!

OR(
AND([Upcoming]<(TODAY()+14),[Upcoming]>= TODAY()),
AND([Upcoming] >= TODAY()-90,[Upcoming] <= TODAY())

Hope this helps someone else who needs it!

2

If I understand your issue, You can use this formula for the slice:

AND(
[Upcoming] <= TODAY() + 14,
[Upcoming] >= TODAY() - 90
)
1 Like