---
schema_version: "1"
id: d345f413cd78f0257754017734df1711e7cf1c723da0aaefcb2a6b21701d6258
title: Date Ranges in MDP
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mcidp_dato_getstarted_dates.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mcidp_dato_getstarted_dates.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 8cf43d32b5d878ec0f3bbe7d054a5016e7de5278d85d5170c4133c3b74762450
description: 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.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Date Ranges in MDP

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.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
      <colgroup>
        <col style="width:34.01360544217687%">
        <col style="width:65.98639455782312%">
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d10689e57">Date Range </th>
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d10689e60">Description</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">Ongoing</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">The data is relevant from the selected start date to the present day (data is valid to
            yesterday).</td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">Yesterday </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">Refers to the day before today.</td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">Week to date</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">
            <p style="margin-bottom:0;">From the beginning of the current week to the current day.</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">Bi-week to Date </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">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.</td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">Month to date</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">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.</td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">Quarter to date </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">From the beginning of the current quarter to the current day.</td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">Year to date </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">From the beginning of the year to the current day.</td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">Previous Week </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">Refers to the week before the current week.</td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">Previous Bi-Week </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">The previous bi-week to date. Bi-week divides the entire year into two-week periods,
            starting from the beginning of the year.</td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">Previous Month </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">The entire month before the current month.</td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">Previous Quarter </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">The entire quarter before the current quarter.</td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">Previous Year </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">The entire year before the current year.</td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">Last 7 Days </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">The past 7 days, not including today.</td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">Last 14 Days </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">The past 14 days, not including today.</td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">Last 30 Days</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 "> The past 30 days, not including today.</td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">Last 90 Days </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">The past 90 days, not including today.</td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">This Week </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">The week in which the current date is in.</td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">This Bi-week </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">
            <p>The bi-week in which the current date falls in. </p>
            <p style="margin-bottom:0;">Bi-week divides the entire year into two-week periods, starting from the beginning of the
              year.</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">This Month</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">The month in which the current date is in.</td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">This Quarter</td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">The quarter in which the current date is in.</td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">This Year </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">The year in which the current date is in.</td>

        </tr>
        <tr class="">
          <td data-label="Date Range" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e57 ">
            <p style="margin-bottom:0;">Custom Date Range </p>
          </td>

          <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d10689e60 ">
            <p>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”.</p>
            <p style="margin-bottom:0;">Saved custom date ranges show up at the bottom of your list in the Date Menu dropdown.</p>
          </td>

        </tr>
      </tbody>
    </table>