Function Names
fqDescription
This function identifies the financial (or fiscal) quarter of the date provided. Example: fq( "2022-02-01", 3 ) returns 4
because February lies in the 4th quarter in the fiascal year ending in March. If a blank date is provided, then 0 is returned.
Vectorization: This function supports vectorization. Sets and nested sets containing input values are also supported.
Call as: function
Restrictions
Indirect parameter passing is disabled
Vectorization is allowed in the 1st function parameter
Parameter count
2
Parameters
| No. | Type | Description |
|---|---|---|
| 1 input |
date or string converted to date set |
Date Value to extract as described above. Vectorization: Put multiple values into a (nested) set. |
| 2 input |
numeral | Month year ending Specify the last month of the financial year (Example: Specify 3 for fiscal years ending on 31. March every year). Value must be between 1 and 12. |
Return value
| Type | Description |
|---|---|
| numeral set |
Result Quarter 1..4. If vectorization is applied, then the multiple values are returned in a set |
Examples
date[] = "2022-05-01";
echo( "Date is ", date[] );
for (month[]=1, month[]<=12, month[]++ )
echo( "Year ending in ", str( date(2022,month[],1),"Mmmm" ), ": ", fq( date[], month[] ) );
echo( fy( { 31.12.2023, 01.01.2023, 06.01.2023 }, 3 ) ); // Vectorization exmapleOutput
Date is 2022-05-01
Year ending in January: 2
Year ending in February: 1
Year ending in March: 1
Year ending in April: 1
Year ending in May: 4
Year ending in June: 4
Year ending in July: 4
Year ending in August: 3
Year ending in September: 3
Year ending in October: 3
Year ending in November: 2
Year ending in December: 2
{2024,2023,2023}