Selector Table
Selector | Description |
Is |
Same as "Equals" or "="; Not case-sensitive. |
Is Not |
Same as "Does Not Equal" or "<>"; Not case-sensitive. |
Is One Of |
Hold the Shift key then highlight and click multiple values from the Criteria. |
Is empty |
Same as "NULL"; Use this selector when looking for criteria with no values entered. |
Is not empty |
Same as "NOT NULL"; Use this selector when looking for criteria with any values entered. |
Before / After |
Used with any relative date criteria and dates fields. For example, Before 1/1/2000 or After 12/31/1999. Or Before Today or After This Week. |
On or Before / After | Used with relative date criteria and dates fields. For example, On or Before 1/1/2000 will include all records before Jan. 1st, 2000, including any records with that date. |
Relative Date Criteria Table
Using Relative Date Criteria to define your reports can take some time to learn. Generally, the relative date criteria are used to limit or expand the period of time for the report query. If you need help using the relative date criteria, contact Zen Planner Support.
Relative Date Criteria | Examples | Description |
Today Tomorrow Yesterday |
Sign up Date is TODAY Next Test date is TOMORROW Last Att. Date is YESTERDAY |
Use these criteria to run daily reports. |
This Next Last |
Sign up Date is THIS Week Next Test Date is NEXT Month Last Att. Date is LAST Month |
Can be used with Day, Week, Month, or Year. |
This Calendar Next Calendar Last Calendar |
Sign up Date is THIS Calendar Week Next Test Date is NEXT Calendar Month Last Att. Date is LAST Calendar Month |
Using Calendar limits the report to the current week or month, instead of the last 7 days or 30 days. |
Next {numeric value} Last {numeric value} |
Next Test Date is NEXT 3 Months Last Att. Date is LAST 6 Months |
Can be used to limit Day, Week, Month, or Year by a specific period. |
This {month} Next {month} Last {month} |
Sign up Date is THIS October Next Test Date is NEXT October Last Att. Date is LAST October |
Used with any month, January - December |
AGO FROM NOW |
Sign up Date is 5 days AGO Next Test Date is 2 weeks FROM NOW |
Can be used with Day,Week, Month, or Year. |