Dates and Times
The date and time criteria editor is used for date and time criteria available on the Data fields tab. Use it to configure criteria for a range of dates and times or perform standard comparison tests against date and time values.
The following options are available for date and time criteria:
- Date - Configure only dates for this criterion
- Date & Time - Configure both dates and times for this criterion.
- Time - Configure only times for this criterion.
- Missing value - Search for instances where this criterion value is null.
Relative date - Search for instances of this criterion value using date operators relative to the current date. The following operators are available for relative date comparison:
- More than - Use this option to search for instances where this criterion is strictly more than X days before today (i.e. X + 1 days before or earlier).
- At least - Use this option to search for instances where this criterion is at least X days before today.
- In exactly - Use this option to search for instances where this criterion is exactly X days after today. To search for days before today, specify a negative value for Days. For example, use -X days with this option to search for instances where this criterion is exactly X days before today.
- In more than - Use this option to search for instances where this criterion is at least X days after today.
- In at least - Use this option to search for instances where this criterion is strictly more than X days after today (i.e. X + 1 days after and later).
- In last - Use this option to search for instances where this criterion is within the last X days.
- In next - Use this option to search for instances where this criterion is within the next X days.
- Occurrences - For more information, see Aggregating Data.
The following additional options are available:
- Exclude – Negate the current condition
- Include missing values – Include results that do not have a value specified for the selected criterion
Previous topic Numbers Next topic Aggregating Data