Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikofba
Contributor II
Contributor II

Day number of Year wrong?

Daynumber.PNG

 

I have a simple chart that has production date as a dimension and Daynumberofyear(max(production date)) and above is what i am getting.

Why are all the sites saying we 11/27/2018 is 331, and not what qlik is saying, 331.  Even when hardcoding daynumberofyear('11/26/2018') it is showing 331.

https://www.epochconverter.com/daynumbers

1 Reply
sunny_talwar

Qlik assumed a year of 366 days

DayNumberofYear

 

=DayNumberOfYear(MakeDate(2018, 2,  28)) = 59
and 
=DayNumberOfYear(MakeDate(2018, 3,  1)) = 61