Relative dates

Learn how to apply relative dates to reports in Report Designer.

Relative dates allow you to create reports that you can run periodically without altering your query. A relative date is a period of time that is relative to the current date (last week, last month, etc.). 

 Note: Relative date functionality is only available with Report Designer.

Apply a relative date to a standard or custom report

  1. Click Reading in the upper-right corner of the open report to switch the report display to Design mode.
  2. Click the Edit button (Screenshot of WorldShare Reports Edit query button) in the Query tab. The Query Panel opens.
  3. From the Query Filters pane, locate the report object you want to apply a relative date to and click the Show prompt properties button (Screenshot of the Show prompt properties button in WorldShare Reports). The Prompt Properties dialog opens.
     Note: If the Show prompt properties button is not visible, click the Define filter type button (Screenshot of the Define filter type button in WorldShare Reports) and select Prompt from the drop-down menu to access it.
  4. From the Prompt Properties dialog:
    1. Select the Parameter from universe radio button.
    2. Select a relative date from the universe parameter list. When you select a relative date, its definition appears below the list.
    3. Click OK.
  5. If the report object has a date range, repeat step 4 for the To date.
  6. Click Apply and Close. 
  7. Save the report.

Available relative dates

 

Name Definition
Yesterday morning 12:00:00 AM institution's local time on the day before the current day.
This morning 12:00:00 AM institution's local time on the current day.
Beginning of last week 12:00:00 AM institution's local time on the first day (Sunday) of the week before the current week.
Beginning of this week 12:00:00 AM institution's local time on the first day (Sunday) of the current week.
7 Days Ago 12:00:00 AM institution's local time 7 days before the current day.
30 Days Ago 12:00:00 AM institution's local time 30 days before the current day.
60 Days Ago 12:00:00 AM institution's local time 60 days before the current day.
90 Days Ago 12:00:00 AM institution's local time 90 days before the current day.
Beginning of this month 12:00:00 AM institution's local time on the first day of the current month.
Beginning of last month 12:00:00 AM institution's local time on the first day of the month before the current month.
2 Months Ago 12:00:00 AM institution's local time on the first day of the month that started 2 months before the current month.
3 Months Ago 12:00:00 AM institution's local time on the first day of the month that started 3 months before the current month.
6 Months Ago 12:00:00 AM institution's local time on the first day of the month that started 6 months before the current month.
9 Months Ago 12:00:00 AM institution's local time on the first day of the month that started 9 months before the current month.
12 Months Ago 12:00:00 AM institution's local time on the first day of the month that started 12 months before the current month.
Beginning of this year 12:00:00 AM institution's local time on January 1 of the current year.
Beginning of last year 12:00:00 AM institution's local time on January 1 of the year before the current year.
2 Years Ago 12:00:00 AM institution's local time on January 1, 2 years ago.