1. Calculation functions
  2. All Functions
  3. Time and Date Functions
  4. CURRENTPERIODEND

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. 

Additional information

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

Related Anaplan functions

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.