Date/Time Into Fiscal Parts

Description

Split a date field into its components fiscal parts:

• FiscalEndingYear

• FiscalStartingYear

• FiscalQuarter

• FiscalHalfYear

• Fiscal Period

• FiscalWeek

When you apply this operation, you are asked to select the fiscal parts you want to derive:

 

Note that the result will depend on the Fiscal Settings you defined in Time Interval Settings.

INPUT/Output DATA TYPE

Input	Output
date	number

 

example

In this example, Hire Date is split into the following parts: Fiscal Quarter, Fiscal Half Year, Fiscal Period, and Fiscal Week on the basis of the following Time Interval setting:

• First Month of the Fiscal Year: January

• Week 1 starts on January 1

We get the following result: