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.

INPERIOD(Date to test, Time period)

ArgumentData typeDescription
Date to testDateThe 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.

The first argument in the function must be a date and not a time period.

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)