Date Search Options
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 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

- checkemptyselection
- find
- Find/Select Dialog
- findabove
- findbackwards
- findbelow
- findid
- findnth
- findselectdialog
- info("empty")
- info("found")
- nextmatch
- Numeric Search Options
- pleaseselectall
- previousmatch
- removeselected
- removeunselected
- search(
- searchanycase(
- select
- selectadditional
- selectall
- selectduplicates
- selectreverse
- selectwithin
- Text Search Options

History

Version | Status | Notes
1.0 | No Change | Carried over from Panorama 6.0