Skip to main content

daynumberofquarter - script and chart function

This function calculates the day number of the quarter in which a timestamp falls.



Return data type: integer

The function always uses years based on 366 days.


DayNumberOfQuarter arguments
Argument Description
timestamp The date to evaluate.
start_month By specifying a start_month between 2 and 12 (1, if omitted), the beginning of the year may be moved forward to the first day of any month. For example, if you want to work with a fiscal year starting March 1, specify start_month = 3.

Examples and results:  

These examples use the date format DD/MM/YYYY. The date format is specified in the SET DateFormat statement at the top of your load script. Change the format in the examples to suit your requirements.

Example 1:  


Returns 74, the day number of the current quarter.

Example 2:  


Returns 12, the day number of the current quarter.
In this case, the first quarter starts with March (because start_month is specified as 3). This means that the current quarter is the third quarter, which started on September 1.

Example 3:  

Add the example script to your document and run it. Then add, at least, the fields listed in the results column to a sheet in your document to see the result.


LOAD recno() as InvID, * INLINE [








] ;


Load *,

DayNumberOfQuarter(StartDate,4) As DayNrQtr

Resident ProjectTable;

Drop table ProjectTable;


The resulting table shows the returned values of DayNumberOfQuarter for each of the records in the table.

Example 3 results
InvID StartDate DayNrQtr
1 28/03/2014 88
2 10/12/2014 71
3 5/2/2015 36
4 31/3/2015 91
5 19/5/2015 49
6 15/9/2015 77

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: