### Summary

Bug: Leap Year Error in Day of Year Function

### Description of the issue

I've created a Filemaker Pro 9 application which creates a calendar for a year where the year is a variable. To account for Leap Years (Days) I've used the following function. I then factor in Leap Year when the result = 366 instead of 365. DayOfYear ("12-31-" & Year ) [where year is a variable entered by the user] However, according to the Gregorian Calendar (the basis for most currently used calendars in the US) the year 2000 and some other years evenly divided by four are not counted as leap years. When using the above noted function for year 2000, a value of 366 is yielded, not the expected 265.

dont88:

Thank you for your post.

The Gregorian Calendar says a leap year occurs every four years, except on the century, unless that century is divisible by 400. That is, 1700, 1800, 1900, 2100, 2200, 2300, 2500, ... are NOT leap years. 1600, 200, 2400 ARE leap years. Therefore, the information you receive is correct. 2000 was a leap year, and it should result in 366.

TSGal

FileMaker, Inc.