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

The PERIOD function converts a date to a time period. 

For example, you can use the PERIOD function to show which financial quarter a date falls under. 

Syntax

PERIOD(Date)

Arguments 

ArgumentData type Description
DateDateThe date to convert the time period from.

The PERIOD function returns a time period. 

Constraints

  • Source must be date formatted.
  • Result must be time period formatted.
  • Result must fall within the time bounds of the model.

Related Anaplan Functions

Examples

In the example, the formula returns the month and quarter for the date 12/02/2015

Period Month has the time period set to month, and Period Quarter has the time period set to quarter.


Key Date
Date12/02/2015

Period Month

PERIOD(Date)

Feb 2015

Period Quarter

PERIOD(Date)

Q1 FY15