Filtering in Reports help needed. Days past and future

Kimbh ✭✭✭✭

Hi, I want to filter a report to show in the next 30 days and in the last 5 days. I have it set Expire Dates is in the next days 30 and Expire dates is in the last 5 days, but it's only showing the past 5 days. I have it set as and so should work. Can someone advise me? Thank you



  • Mike TV
    Mike TV ✭✭✭✭✭✭

    What results do you get when you change it from "and" to "or"? Are they the results you're after?

    The problem with an "and" here I believe is that it's trying to find a single row that the date is both in the next 30 days and in the next 5 days. Since in the next 5 days is in the next 30 days, it'll just find those in the next 5 days. An "or" might work if that's what you're after.

    If changing it to an "or" isn't what you want to see, you might need another new column that may need to include the TODAY(30) function, I believe.