# InDateRange

The **InDateRange** function determines if an inputted date is within a specified range of dates, returning True or False.

### Syntax

```
InDateRange([date column], [direction], [period], [length], [offset], [today])
```

Function arguments:

* **date column** (required) - The date to be evaluated.
* **direction** (required) - The direction to apply the date range offset.
  * Enter `last` to set the date range to the most recent window.
  * Enter `next` to set the date range to the upcoming window.
  * Enter `current` to set the date range to the current window.
  * Enter `to_date` to set the date range to the current window up until the current date. 
* **period** (required) - The size of date window
  * options: `year`, `quarter` , `month`, `week`, `day`, `hour`, `minute` , and `second`
* **length** (optional) - The number of periods to include in the date range
  * If not set, defaults to `1`
* **offset** (optional) - The number of periods to offset for the start date range
  * If not set, defaults to `0`
* **today** (optional) - The value to use for Today when calculating with respect to the current date
  * If not set, defaults to `Today()`

### Example

Returns `True` for all dates in the current month:

```
InDateRange([Date], "current", "month")
```

Returns `True` for all dates in the last three weeks:

```
InDateRange([Date], "last", "week", 3)
```

Returns `True` for all dates in the week starting three weeks ago:

```
InDateRange([Date], "last", "week", 1, 3)
```

Returns `True` for all dates within the last year up to today's date:

```
InDateRange([Date], "to_date", "year", 1, -1)
```