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, Month, Quarter 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 |
|---|---|
| Returns |
See also
Related articles: DAYSINPERIOD, PRORATA
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!