Event Filter Dates - The Event Filter Options allow you to filter report results by selecting one event and then selecting a date range for that specific event. For example, you can filter the data to only include assets that have a Completion Date within the past two weeks.

The Filter On drop down allows you to select an event such as Skillport Registration date, Last Login date, High Score, etc. The available events vary based on the template selected.

The Previous option allows you to select an interval of time that is relative to today, or the date the template is accessed. The dates are dynamic and update each time the template is accessed either manually or from a schedule. This option is useful when you want to create recurring schedules that generate results with the most current data. This option is explained in detail below.

The From/To option allows you to select specific start and end dates. If a value is entered for both the start and end date, the dates are static and do not update if the template is accessed in the future. Typically this option is useful when you want a one-time snapshot of data. This option is explained in detail below.

Note: When the Previous option is selected, the dates that correspond to the 'Previous [n] [Units]' will display in the From/To option and will refresh accordingly. This provides a valuable aid to help you understand the nature of the dates you are selecting.

Previous Option

The intervals for the Previous option include Days, Weeks, Months and Years and each is bound by specific start and end dates, as well as times. You can also select the number of intervals to include, for instance '3 Months' or '2 Weeks'. Each interval has a maximum limit as defined below:

• Years – 99
• Months – 999
• Weeks – 999
• Days – 9999

The Previous option also provides a To Date setting that allows you to include all activity up to the current date and time, regardless of the interval chosen.

• If To Date is unchecked, the end date is the last day of the previous interval. For instance, if today is December 31, the ‘Previous [n] Months’ ends on November 30 and the ‘Previous [n] Years’ ends on December 31 of the prior year.
• If To Date is checked, the end date is always the date the report is run, up to and including the most recent database refresh.

The start and end dates for each interval are defined below.

• Day intervals
  • Starts at 00:00:00 or 12 midnight, ends at 11:59:59.
  • Example: If today is any time on October 31, then the 'Previous 3 Days' starts on October 28 at 00:00:00 and ends on October 30 at 11:59:59.

  Note: All times are UTC.

  Note: For all intervals listed below, the start and end times are the same as those noted for Day intervals.

• Week intervals
  • Starts on Sunday, ends on Saturday.
  • Examples with To Date Unchecked
    • If today is Sunday October 31, then the ‘Previous 2 Weeks’ starts on Sunday October 17 and ends on Saturday October 30.
    • If today is Wednesday November 3, then the 'Previous 2 Weeks' starts on Sunday October 17 and ends on Saturday October 30.
  • Example with To Date Checked
    • If today is Wednesday November 3 then results for the 'Previous 2 Weeks' starts on Sunday October 17 and ends on Wednesday November 3.
• Month intervals
  • Starts on the first day of the month, ends on the last day of the month.
  • Examples with To Date Unchecked
    • If today is October 31, then the ‘Previous 3 Months’ starts on July 01 and ends on September 30.
    • If today is November 3, then the ‘Previous 3 Months’ starts on August 01 and ends on October 31.
  • Example with To Date Checked
    • If today is November 3 then the ‘Previous 3 Months’ starts on August 01 and ends on November 3.
• Year intervals
  • Starts on the first day of the year, ends on the last day of the year.
  • Examples with To Date Unchecked
    • If today is October 31, 2010, then the ‘Previous 2 Years’ starts on January 1, 2008 and ends on December 31, 2009.
    • If today is any day in 2010, then the ‘Previous 3 Years’ starts on January 1, 2007 and ends on December 31, 2009.
  • Example with To Date Checked
  • If today is November 3, 2010 then the 'Previous 2 years' starts on January 1, 2008 and ends on November 3, 2010.

Note: For all settings that have an end date of today, the results are dependent on the last successful automatic database refresh.

From/To Option

The From/To option allows you to set specific dates.

When using the From/To option you must adhere to the following guidelines:

• The To date can be left blank. The From date cannot be left blank.
• If the To date is blank, the end date is always the date the report is run, up to and including the most recent database refresh.
• The From date is always the beginning of the day and starts at 00:00:00 or 12 midnight UTC. The To date is always the end of the day and ends at 11:59:59 UTC.
• All dates must be entered in the format YYYY-MM-DD. For instance, 2010-01-01.
• The To date must be later in time than the From date.

  Note: If you are modifying chart activity dates, there is a limit to the length of time that can be included in the Previous or From/To options. For more information, see Modify Chart Activity Dates.

To apply Event Filter options

1. Click the Filter Options tab.
2. Select an event from the Filter On drop-down.

   Note: The available events will vary depending on the template selected. For a description of each event see the Report Definitions and refer to the corresponding report. Locate the event in the Display Options section.

3. Select either the Previous or From/To option.
4. To modify the dates, follow the guidelines above based on the option selected.