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 | 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.
The first argument in the function must be a date and not a time 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
|
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?
|
