Skip to main content

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 (6.1)

Suggest edit Updated on September 20, 2019

Summary

Symbolic dates allow you to choose date values in a report definition rule that are relative to the current date, such as "Yesterday", rather than absolute dates such as "July 9, 2009". This adds flexibility to the report, while at the same time making it easier to use. You can use symbolic dates in both the rule form and the report itself for values of Date and DateTime properties only.

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 report definition rule 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 with different symbolic dates to see the effect of different date options.

  1. Create a report definition rule.
  2. On the Design tab, in the Columns To Include section, specify four columns to display each object's label, work ID, creation date and time, and status:

columns in report definition

  1. In the Rows To Include section, enter the following:

rows to include

  1. Set the range of .pxCreateDateTime using a symbolic date in the Valuefield of condition "A":
    1. Click the magnifying glass icon ( magnifying glass icon ) to the right of the Value field. The Pick Value screen appears.
    2. Select the Time Periods tab to display the available symbolic dates:
      available symbolic dates
    3. Scroll down to find Today, select it, and click Ok.
  2. Click the Run run icon icon. The report displays only the work objects created today:

report showing objects created today

  1. Edit the rule by selecting a different symbolic date value, save it, and click the Run run icon icon again to see how the change in symbolic date value affects the report's output.

Tags

Pega Platform 7.1.1 - 7.4 Reporting Financial Services Healthcare Insurance Media and Advertising Government Life Sciences Utilities Hospitality and Entertainment Manufacturing Retail
Did you find this content helpful? YesNo

100% found this useful

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