Files to look at:

• Form1.cs
• Fiscal Functions

This example shows how to find the number of a fiscal year, quarter, and week for date-time data fields.

In this example, the Grid dashboard item displays the fiscal year, quarter and week for the corresponding date.

The following expressions calculate fiscal values for the corresponding date.

All Fiscal methods extend GetFiscalDateFunction and override the GetFiscal method used to calculate fiscal values.

Returns the year of input DateTime if it comes before a new fiscal year beginning date; otherwise returns the year plus 1.

• If a difference between the input DateTime month, and the startMonth field not divisible by 3, the GetFiscal method returns the whole fraction of the difference by 3 plus 1; otherwise the fiscal quarter function calculates the result for the previous or next month of given DateTime depending on whether the input DateTime day is less or more than the startDay field.

1. The Beginning method sets the start date of the first week in the input year.
2. If start date is less, than input date start = Beginning(current.Year); otherwise start = Beginning(current.Year - 1).
3. The function calculates the result as a sum of a difference between the start and input dates and the day of week offset from the first day of week divided by 7.

• DateTime
• Expression Constants, Operators, and Functions