Edit online

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:

    Note: The options for Relative date work in GMT only.
    • 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