Use a date range to display specific data. You can set a date range for a pivot table, and a report. You can select a predefined date range from the date picker, such as Last 30 days or This Month, or you can enter a range. When you set a date range, your data updates according to the dates selected.
When setting a date range, the following rules apply.
- When the date range is a calendar segment (day, week, or month), Marketing Cloud Intelligence Data Pipelines uses the beginning of the calendar period and doesn’t count the days back from the current date. For example, if you select Previous Week in the date picker, it isn’t counted as today minus seven days. Instead, it goes to the week previous to the current week and starts the range on the first date that the previous week started from.
- The first day of the week is Monday, so Sunday is considered part of the previous week. You can change this preference using the Custom Calendar feature.
This table lists the MDP date range options.
| Date Range | Description |
|---|---|
| Ongoing | The data is relevant from the selected start date to the present day (data is valid to yesterday). |
| Yesterday | Refers to the day before today. |
| Week to date |
From the beginning of the current week to the current day. |
| Bi-week to Date | Includes information from the beginning of the calendar bi-week. Bi-week divides the entire year into two-week periods. This refers to a specific two weeks, depending on the count from the beginning of the year. |
| Month to date | Includes information from the beginning of the calendar month. For example, if you set this date range to April 15, it pulls data from the beginning of April and shows 15 days worth of data. |
| Quarter to date | From the beginning of the current quarter to the current day. |
| Year to date | From the beginning of the year to the current day. |
| Previous Week | Refers to the week before the current week. |
| Previous Bi-Week | The previous bi-week to date. Bi-week divides the entire year into two-week periods, starting from the beginning of the year. |
| Previous Month | The entire month before the current month. |
| Previous Quarter | The entire quarter before the current quarter. |
| Previous Year | The entire year before the current year. |
| Last 7 Days | The past 7 days, not including today. |
| Last 14 Days | The past 14 days, not including today. |
| Last 30 Days | The past 30 days, not including today. |
| Last 90 Days | The past 90 days, not including today. |
| This Week | The week in which the current date is in. |
| This Bi-week |
The bi-week in which the current date falls in. Bi-week divides the entire year into two-week periods, starting from the beginning of the year. |
| This Month | The month in which the current date is in. |
| This Quarter | The quarter in which the current date is in. |
| This Year | The year in which the current date is in. |
|
Custom Date Range |
The custom date range allows you to select any range of dates you would like and save them to show up across the workspace. This option is commonly used when you want to show a specific date range in your reports. For example “Last 45 days”. Saved custom date ranges show up at the bottom of your list in the Date Menu dropdown. |