1. Calculation functions
  2. All Functions
  3. Time and Date Functions
  4. INPERIOD

The INPERIOD function returns a TRUE result for a date that falls under a time period or a module's Time dimension. It returns FALSE for all other dates.

For example, you can use the INPERIOD function to show new employees at a company in the last year.

Syntax

INPERIOD(Date to test, Time period)

Arguments

ArgumentData typeDescription
Date to testDate, time periodThe date to test if it falls under a time period or Time dimension.
Time period (Optional)Time period

The time period to test.

If your module does not have Time as a dimension, this argument is required.

The INPERIOD function returns a Boolean result.

Related Anaplan functions

PERIOD

Examples

In this example, an Employee Details module has line items on rows, the Employees list on columns, and Time on pages. Start date has a date format, and New employees FY21 has a Boolean format.

The formula returns a TRUE result for new employees in FY21. It returns FALSE for all other employees.


Employee AEmployee BEmployee CEmployee D
Start date12/03/20215/06/202015/03/202117/08/2018

New employees FY21

INPERIOD(Start date)



Another example of the Employee Details module does not have Time as a dimension. Start date has a date format, Month period has the time period format set to months, and Is in period? has a Boolean format.

The formula returns a TRUE result for employees with the correct Start date and Month period.


Employee AEmployee BEmployee CEmployee D
Start date12/03/20215/06/202015/03/202117/08/2018
Month periodMar 21May 20Mar 21Sept 18

Is in period?

INPERIOD(Start date, Month period)