Setting 'From' and 'To' Dates and Times When Running a Report
Historical and Intra-day reports require a date range for the data that is to be returned. There are two kinds of date range parameters:
-
Fixed Dates represent a specific point in time, for example, 2018-01-01 11:59:59
-
Relative Dates are relative to the time the report is run, for example ‘Last Month’
Relative dates are useful when saving a report to run automatically when it is opened when it is part of a dashboard app, or for a scheduled report delivery. For example, save a report to return data for the previous day by using the relative date ‘Yesterday’ as the date From and Date To parameter.
Fixed Dates, relative dates, or a combination of both can be used when running a historical report.
The following table gives some examples of date parameters and the date ranges they specify. For the purpose of these examples, the current date is Thursday 20th September 2021.
|
From |
To |
Date Range |
|---|---|---|
|
Yesterday |
Today |
2018-09-19 00:00:00 to 2018-09-20 23:59:59 |
|
Yesterday |
Yesterday |
2018-09-19 00:00:00 to 2018-09-19 23:59:59 |
|
Last Week* |
Last Week |
2018-09-19 00:00:00 to 2018-09-15 23:59:59 |
|
Last Month |
Last Month |
2018-08-01 00:00:00 to 2018-08-31 23:59:59 |
|
Last Month |
This Month |
2018-08-01 00:00:00 to 2018-09-30 23:59:59 |
|
Last 7 Days |
Last 7 Days |
2018-09-13 00:00:00 to 2018-08-19 23:59:59 |
|
Last 3 Months |
Last 3 Months |
2018-06-01 00:00:00 to 2018-08-31 23:59:59 |
|
Last Year |
Last Year |
2017-01-01 00:00:00 to 2017-12-31 23:59:59 |
|
Last Year |
This Year |
2017-01-01 00:00:00 to 2018-12-31 23:59:59 |
|
This Year |
2018-07-01 11:30:00 |
2017-01-01 00:00:00 to 2018-07-01 23:59:59 |
*The start day of the week is Sunday for Analytics instances that are predominantly used in North America, or Monday for Analytics instances that are predominantly used elsewhere.
If the date range contains data that has not yet been processed by Analytics, then the report only displays the data available when the report is run. For example, if a report shows a row of data for each day and the date range specified includes today, then the row for today only includes the data that has been processed at the time the report is run.