Determining if date is before a certain day of year
I use Filemaker Pro for academic records, and I need to use it to determine the graduation year for students. I have narrowed it down to a simple algorithm (I think), but I can not figure it out how to do it.
I want the database to determine whether the current date is before a certain day of the year regardless of the actual year. For example, if the current date is before June 1st of a given year, it should return the current year. If it is after June 1st, it would return the current year plus one.
So, if the date is May 20, 2014, it would return "2014." If the date is August 6, 2014, it would return 2015 (because 2014 + 1).
Most of the date calculations include a specific year, and I want the calculation to work regardless of the year.