> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# InPriorDateRange

> Use the Sigma InPriorDateRange function to determine if an inputted date is within a specified date range in a previous time period, returning True.

The **InPriorDateRange** function determines if an inputted date is within a specified date range in a previous time period, returning True or False.

## Syntax

```
InPriorDateRange([date column], [range period], [prior period], [offset], [today])
```

Function arguments:

* **date column** (required) - The date to be evaluated.
* **range period** (required) - The period for the date range
  * options: `year`, `quarter` , `month`, `week`, `day`, `hour`, `minute` , and `second`
* **prior period** (required) - The period used to offset the range period.
  * options: `year`, `quarter` , `month`, `week`, `day`, `hour`, `minute` , and `second`
* **offset** (optional) - The number of prior periods to offset by.
  * If not set, defaults to `1`
* **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 hour of the day in the previous day:

```
InPriorDateRange([Date], "hour", "day")
```

Returns True for all dates in this month last year:

```
InPriorDateRange([Date], "month", "year")
```

Returns True for all dates in this month two years ago:

```
InPriorDateRange([Date], "month", "year", 2)
```

## Related resources

* [InDateRange](/docs/indaterange)