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

 Argument Data type Description Date to test Date, time period The 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.

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 A Employee B Employee C Employee D Start date 12/03/2021 5/06/2020 15/03/2021 17/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 A Employee B Employee C Employee D Start date 12/03/2021 5/06/2020 15/03/2021 17/08/2018 Month period Mar 21 May 20 Mar 21 Sept 18 Is in period? INPERIOD(Start date, Month period)