Follow

Filter Report Dates and Edit Report Criteria

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.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk