Page 1 of 1

November 31st?

Posted: Wed Sep 20, 2017 1:34 am
by bru888
I did a double-take while testing my scenario just now. November 31?
Screenshot 5.jpg
Screenshot 5.jpg (16.29 KiB) Viewed 434 times
It's not a year-specific bug. That was 1945. I created another November 31 for 1941:
Screenshot 7.jpg
Screenshot 7.jpg (8.07 KiB) Viewed 434 times
Screenshot 8.jpg
Screenshot 8.jpg (12.54 KiB) Viewed 434 times
And it's not about October 1 in itself as a starting point. I used this formula to create yet another November 31:
Screenshot 9.jpg
Screenshot 9.jpg (8.78 KiB) Viewed 434 times
It seems whatever formula you use, if it will calculate to "November 31" on a particular turn, that erroneous date will display.