Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Brit,
this is because QV works Year Base 366 days.
DayNumberOfYear('3/1/2017') -> 61
Regards,
Antonio
Hi Brit,
this is because QV works Year Base 366 days.
DayNumberOfYear('3/1/2017') -> 61
Regards,
Antonio
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.
I agree with You.
Regards,
Antonio