Date/Time Into Fiscal Parts


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







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:





© 2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support