AnsweredAssumed Answered

Determining if date is before a certain day of year

Question asked by EV on Aug 31, 2014
Latest reply on Aug 31, 2014 by schamblee

Title

Determining if date is before a certain day of year

Post

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.

Outcomes