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.


The CURRENTPERIODEND function does not use any arguments.

This function returns a date result.

Syntax example


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

Additional information

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

Related Anaplan functions



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.


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