Examples of Reports Date Range

For details about the combinations of the report generation date, closing day, start date, and end date, see the following examples. The calendar under each example shows the date range to be included in the report.

Here is the list of examples:

Example 1

Generate a report that starts from June 10 to July 10.

  1. In From, click the calendar icon.

  2. Select June 10 from the calendar.

  3. In To, click the calendar icon and select July 10 from the calendar.

The resulting Date Range will be:

Example 2

Generate a report that started 2 months ago until yesterday.

  1. In From, click the dropdown menu and select N months ago.

  2. A box is displayed beside From, then enter number 2. This means the report will be generated using the data gathered two months ago. If the current date is July 10, two months ago will be May 10.

  3. In To, click the dropdown menu and select Yesterday.

The resulting Date Range will be:

Example 3

Generate a report that starts last week until the next four months.

  1. In From, click the dropdown menu and select Current day of last week. For example, the current day is July 10, and if this option is selected, the From date will be July 3.

  2. In To, click the dropdown menu and select N months from now.

  3. A box is displayed beside To, then enter the number 4. This means that the report will be generated using the data gathered last week (July 3) until the next four months (November 10).

The "N months from now" refers to the future months.

  • If you set a scheduled monthly report for the next five months, every report generated will cover the last week until the current month. For example, today is September 11, and the data retrieved is from July 3 until September 10.

  • In the fifth scheduled month (December), the report will be the same as the report generated in the fourth month (November) because the To field only specifies 4 months from now covering from July 3 until November 10.

  • The same mechanism applies to N days from now and N weeks from now.

The resulting Date Range will be:

Example 4

Generate a report that starts two days ago until the next three months.

  1. In From, click the dropdown menu and select N days ago.

  2. A box is displayed beside From, then enter number 2. This means the report will be generated using the data gathered in the last two days.

  3. In To, click the dropdown menu and select N months from now.

  4. A box is displayed beside To, then enter the number 3. This means the report will be generated using the data gathered from two days ago (July 8) until the next three months (October 10).

The "N months from now" refers to the future months.

  • If you set a scheduled weekly report, every report generated will cover the last two days until the current month. For example, today is September 11, and the data retrieved is from July 8 until September 10.

  • In the third week of October (October 17), the scheduled report will be the same as the report generated in the second week of October because the To field only specifies 3 months from now covering from July 8 until October 10.

The resulting Date Range will be: