How to make a report that includes only dates within the past 60 days?

JMoberg

When I set up my report using "is not in the last (days)" then add 59 after it, the report is considering blank dates as true. I need it to ignore blanks. I need the row to be in the report if any one of the dates is past that point. The ones that are blank are due to the person not being trained in that area.

AKnight

Hi @JMoberg!

I would add a condition for each row using the condition "is not blank". I am assuming your grouping is currently AND for "Cross Trained" is checked + is not in the last 59 days group, I would just add conditions under your "Cross Trained" condition. It would look like:

Cross Trained, is checked AND

USS Packout is not blank AND

USS Induct is not blank AND .. so on

This will require the report to filter out any rows that have blank date columns.

Hope this helps!

-Ashley