Problem with DayNumberOfYear()

[Anonymous]

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:

31

59

91

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

[antoniotiman · Accepted solution]

Hi Brit,

this is because QV works Year Base 366 days.

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

Regards,

Antonio

[Anonymous]

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]

I agree with You.

Regards,

Antonio