topic Re: Problem with DayNumberOfYear() in QlikView

Problem with DayNumberOfYear()

Anonymous — Tue, 27 Jun 2017 13:49:30 GMT

It appears that there are now 32 days in March.

I put the following in a text box:

=DayNumberOfYear('1/31/2017') & chr(13) &
DayNumberOfYear('2/28/2017') & chr(13) &
DayNumberOfYear('3/31/2017') & chr(13) &

And this is what I get:

I don't believe I had this problem until I updated to version 12. Am I missing something or is this a bug?

antoniotiman — Tue, 27 Jun 2017 14:09:59 GMT

Hi Brit,

this is because QV works Year Base 366 days.

DayNumberOfYear('3/1/2017') -> 61

Regards,

Antonio

Anonymous — Tue, 27 Jun 2017 14:16:49 GMT

Ok, thanks. I should have gotten my hands on a reference manual first. Always using years based on 366 days doesn't seem like a good idea, though.

antoniotiman — Tue, 27 Jun 2017 14:23:03 GMT

I agree with You.

Regards,

Antonio