The Search Ads 360 Query Language lets you specify the date range in two ways:

- custom date range

- predefined date range

## Custom date range

You can specify dates in ISO 8601(`YYYY-MM-DD`) format:

    segments.date BETWEEN '2019-01-01' AND '2019-01-31'

    segments.date >= '2019-01-01' AND segments.date <= '2019-01-31'

### Time periods

Some date fields refer to a predefined period of time, specifically:

- `segments.week`
- `segments.month`
- `segments.quarter`

When filtering on these segments, you can use the `=` operator with the date
that is the first day of the time period. Starting in v9, if you specify a date
that is not the first day of a period, a `MISALIGNED_DATE_FOR_FILTER` error is
returned.

For example, to specify the month of May in the year 2021, you would use the
following condition, specifying the first day of that month:

    segments.month = '2021-05-01'

## Predefined date range

The list of valid predefined date ranges is as follows:

| Date range | Reports are generated for... |
|---|---|
| `TODAY` | Today only. |
| `YESTERDAY` | Yesterday only. |
| `LAST_7_DAYS` | The last 7 days not including today. |
| `LAST_BUSINESS_WEEK` | The 5 day business week, Monday through Friday, of the previous business week. |
| `THIS_MONTH` | All days in the current month. |
| `LAST_MONTH` | All days in the previous month. |
| `LAST_14_DAYS` | The last 14 days not including today. |
| `LAST_30_DAYS` | The last 30 days not including today. |
| `THIS_WEEK_SUN_TODAY` | The period between the previous Sunday and the current day. |
| `THIS_WEEK_MON_TODAY` | The period between the previous Monday and the current day. |
| `LAST_WEEK_SUN_SAT` | The 7-day period starting with the previous Sunday. |
| `LAST_WEEK_MON_SUN` | The 7-day period starting with the previous Monday. |

Example:

    segments.date DURING LAST_30_DAYS