DayNumberInQuarter Question

[dafnis14]

Hi,

DayNumberOfQuarter('28/02/2019')  shows 59

DayNumberOfQuarter('01/03/2019') shows 61

DayNumberOfQuarter('29/02/2020')  shows 60 (leap year)

Is it a bug or a feature?

Thanks!

[Arthur_Fong · Accepted solution]

Is stated in Qlik help document that:

The function always uses years based on 366 days.

Refer to Qlik help for more info:

https://core.qlik.com/services/qix-engine/script_reference/date_and_time_functions/#daynumberofquart...

Thanks and regards,

Arthur Fong

[dafnis14]

Thank you!