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

[beckythecoolest]

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!

[T_I_Phong]

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

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