LinkedIn
Copied!

Table of Contents

Dates and Times

Version:

Only available versions of this content are shown in the dropdown

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
Did you find this content helpful?

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.