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