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

The START function returns the first date of a time period. 

Syntax 

START( ) 

START(Time period)

START(TIME. 'Period')

Arguments

ArgumentData typeDescription
Time periodDateThe time period used to find the first date. 
TIME. 'Period'DateThe hard-coded time period used to find the first date, with reference to the source timescale settings.

If you do not include an argument, START returns the first date of the source module's time dimension. 

If you include an argument, the START function returns a date. 

Additional information 

The format used to display the date depends on your OS/browser settings. For example, the U.S. date format displays the month before the day (mm/dd/yyyy).

Constraints

  • If you use a parameter, the source must be time period formatted. 
  • If the time period is blank, the result is blank.
  • Result must be date formatted. 

Related Anaplan functions

Examples

The example below shows START( ). No parameter is used and the module is time period formatted for months. 


Jan 14Feb 15

Period Start Date

START( )

01/01/201401/02/2014

The example below shows START with a parameter. Start Month is formatted for months and Start Quarter is formatted for quarters.


Key DatesExpiry Dates
Month PeriodFeb 14Apr 16
Quarter PeriodQ2 FY14Q3 FY16

Start Month

START(Month Period)

01/02/201401/04/2016

Start Quarter

START(Quarter Period)

01/04/201401/07/2016

The final example below shows START with a hard-coded parameter. The current year is set to FY16 and the model Time Scale includes the past 2 years. 


Key DatesExpiry Dates
Month PeriodFeb 14Apr 15
Quarter PeriodQ2 FY14Q3 FY14

Start Date Absolute 

START(TIME.'FY14')

01/01/201401/01/2014