How helpful was this page? 

Your Rating:
1 Star2 Star3 Star4 Star5 Star
5 rates

Tell us what we can improve.

Save as PDF

Relative Dates

Last Updated: May 16, 2022 15:53

Relative Dates are essential for Scheduled Reports. For example, scheduling a report based off of copies added in the last month will always pull data for the month prior to the date the report is run, and not a month prior to when the report was originally scheduled.

A Date Range is the time in between two specified dates such as 01/01/17–02/15/17.

A Relative Date is a generalized time period, such as a week or a month, rather than specific dates.

When selecting Relative Dates, you have the ability to specify the time period you will view on the report. You will notice when Last or This is selected a text box appears in between the two drop down menus, this box is so you may enter the number of days, weeks, months, or years you would like to view.

You must specify at least 1 day, week, month, year in order for the selector to work. Here are the options and how they work in more detail:


  • 1 Day. Yesterday or prior to yesterday. It will not show anything from the current day (today).
  • 1 Week. The previous Sun–Sat week; not the previous 7 days. 
  • 1 Month. The previous calendar month.
  • 1 Year. The previous calendar year.


  • Day. Today, starting at midnight, or anything date-stamped the current day.
  • Week. The current Sun–Sat week.
  • Month. The current calendar month.
  • Year. The current calendar year.