When searching in a date field there are over two dozen options for determining whether data is a match.

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 January 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 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. (The exact comparison is any date within 31 days before or after the specified date.)


See Also


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0