---
title: "Use the INPERIOD Function to Check If a Date Falls Within a Period"
slug: "inperiod-function"
description: "Learn to use the INPERIOD function to check if a date falls within a specified time period in Pigment."
updated: 2025-10-29T14:39:31Z
published: 2025-10-30T09:30:13Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# INPERIOD function

## Description

Returns `True` if a given Date is included in a time period.

## Syntax

`INPERIOD(Date, Time Dimension)`

## Arguments

| Argument | Type | Dimensions | Description |
| --- | --- | --- | --- |
| *Date* (required) | Date | Same Dimension as *Time Dimension* | Date to compare. |
| *Time Dimension* (required) | Dimension | Time Dimension | Must be a Time Dimension based on the Calendar settings. The available options are: Day, Week, Month, Quarter, Half or Year. |

## Returns

| Type | Dimensions |
| --- | --- |
| Boolean | *Time Dimension* |

`TRUE` if a Date is included in the time period.

`BLANK` if a Date is not included in the time period.

## Examples

| Formula | Description |
| --- | --- |
| `INPERIOD('Product'.'Expiration Date'[add: Month], 'Month')` | Returns `TRUE` on Month for which the Product Expiration Date is in, `BLANK` otherwise. |

## See also

Related articles: [DAYSINPERIOD](/v1/docs/daysinperiod-function), [PRORATA](/v1/docs/prorata-function)

> [!TIP]
> **More of a hands-on learner?**
> 
> Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!