Contents
this page has been moved to https://support.goalexandria.com/knowledge-base/best-practices-for-relative-dates/
A relative or adaptive date can be substituted for an actual date within Alexandria or Textbook Tracker. They are especially helpful when creating and running Saved reports. Relative dates allow you to add selection criteria for a particular date range that will be remembered in a saved report, without requiring future modification. For example, relative dates could be used to set a specific Due Date range as the Select By criteria for an Overdue report (e.g. %lastweek). These report settings can then be saved and the correct information will be gathered each time that report is needed.
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/19–02/15/19.
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:
Last
- 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.
This
- 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.
Adaptive Date Commands
In general we recommend using the Relative Dates selection as detailed above. However, you can also use these commands in the regular date field.