When specifying a date you can use Smart Dates, so you can use dates like March 12, yesterday, or last tuesday as well as more conventional dates like 3/12/18.
Is Equal to (=) — Any data cell that exactly matches the match value will be identified as a match.
Is Not Equal to (≠) — Any data cell that does not exactly match the match value will be identified as a match.
Is Before — Any data cell that contains a date before the date you type into the box on the right will be identified as a match.
Is on or Before — Any data cell that contains a date before or on the date you type into the box on the right will be identified as a match.
Is After — Any data cell that contains a date after the date you type into the box on the right will be identified as a match.
Is on or After — Any data cell that contains a date after or on the date you type into the box on the right will be identified as a match.
Is Between — Any data cell that contains a date between the two specified dates will be identified as a match. In this example all checks between last tuesday and today are selected (the example was taken on March 9, 2017).
Is Not Between — Any data cell that contains a value outside the two specified dates will be identified as a match.
Is Not Empty — Any data cell that contains a any date will be identified as a match. Blank cells will not be selected.
Is Empty — Any data cell that does not contain a value will be identified as a match. In other words, this option locates completely blank fields.
Is Today — Any data cell with today’s date is identified as a match.
Is This Week — Any data cell in the current week is identified as a match.
Is This Month — Any data cell in the current month is identified as a match.
Is This Quarter — Any data cell in the current quarter (3 months) is identified as a match.
Is This Year — Any data cell in the current year is identified as a match.
Is Within 3 Days of — Any data cell that contains a date within 3 days of the specified date will be identified as a match.
Is Within 7 Days of — Any data cell that contains a date within a week of the specified date will be identified as a match.
Is Within 1 Month of — Any data cell that contains a date within a month of the specified date will be identified as a match.
See Also
History
Version | Status | Notes |
1.0 | No Change | Carried over from Panorama 6.0 |