Skip to main content

Dates and Times

Suggest edit
Updated on January 19, 2022

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.

Pega Customer Decision Hub

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? YesNo

Have a question? Get answers now.

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

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us