Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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