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 the DateTime input if it is before the start of a new fiscal year; 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.

• The Beginning method sets the start date of the first week in the input year. If start date is more, than input date, the program calculates start date for the previouse fiscal year.
• The function calculates the result as a sum of differences 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