I am working on a scheduling app that should exclude a player from the schedule if (s)he will not be available (due to vacation, training, or some other issue) on the date the schedule is being created. This seems to work fine except in one case where the start date of the player's unavailability begins in one year and ends in the next. Here's an example:
Start Date: 12/22/2014
End Date: 01/05/2015
Schedule Date: 12/29/2014
Obviously the Schedule Date falls between the Start Date and the End Date however this player continues to show up on the schedule that I create for 12/29/2014.
I'm attaching a copy of the record that should be affected by the query as well as the query itself. Please let me know if you need additional information. Thanks in advance for your help.