The CURRENTPERIODEND function returns the end date from a model's current period.

For example, you can use the CURRENTPERIODEND function to ensure that a formula only applies to a specific week in the current period.

## Arguments

The CURRENTPERIODEND function does not use any arguments.

This function returns a date result.

## Syntax example

CURRENTPERIODEND()

In this example, the formula returns the end date from the current period.

You can set your model's Current Period in Time in the model settings bar.

## Examples

PERIOD(CURRENTPERIODEND() + 1)

In this example, the formula returns the first time period after the model's current period. If the model's current period is Jan 20, it returns Feb 20.

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.