Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

How to use symbolic dates in report selection criteria

Updated on April 29, 2020

Summary

Symbolic dates allow you to choose date values in a list or summary view that are relative to the current date. They can be used on both the rule form and in the report itself. Symbolic dates are only used for values of Date and DateTime properties.

Some symbolic dates identify a single day, such as Yesterday or Tomorrow. Others define a range of dates, such as Current Month or Previous Quarter. Here is a list of all available symbolic dates:

Calendar YearCalendar QuarterCalendar MonthCalendar WeekDay
Current YearCurrent QuarterPrevious MonthPrevious WeekYesterday
Previous YearCurrent and
Next Quarter
Current MonthCurrent WeekToday
Previous 2 YearsCurrent and
Previous Quarter
Next MonthNext WeekTomorrow
Next YearNext QuarterCurrent and
Previous Month
 Last 7 Days
Current and
Previous Year
Previous QuarterCurrent and Next Month Last 30 Days
Current and
Previous 2 Years
   Last 60 Days
Current and Next Year   Last 90 Days
    Last 120 Days
    Next 7 Days
    Next 30 Days
    Next 60 Days
    Next 90 Days
    Next 120 Days

 

Suggested Approach

To see how you can use symbolic dates in a report, create a list view that displays all work objects created in your application. Then reference a symbolic date to restrict the range of detail in the report based on the date chosen. Repeat the process to see the effect of the different date options.

  1. Create a list view.
  2. On the Display Fields tab, under the Show These Fields section, enter the following:

The fields entered under this section populate the columns in the list view.

  1. On the Content tab, under the Criteria section, enter the following:

.pxCreateDateTime allows you to define the range of the list view using symbolic dates.

  1. To select a symbolic date to use as the default value for .pxCreateDateTime, click the Search Values icon. The Calendar Web page dialog displays.

  1. On the Time Periods tab, under Day, select Today and click Apply.
  2. Click the Save icon to save the list view.
  3. Click the Run icon. The list view displays. All work objects created today display in the report.

  1. Click the Customize list criteria link. The Customize Criteria section displays. Change the value of .pxCreateDateTime from Today to Previous Week and click Submit.

  1. The List view now changes to reflect the the new criteria value. The report now displays all work objects created during the previous week.

Tags

Pega Platform 7.1.1 - 8.3.1 Reporting Financial Services Healthcare and Life Sciences Insurance Communications and Media Government Healthcare and Life Sciences Consumer Services Consumer Services Manufacturing Consumer Services

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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