Todd Penland
asked on
Unexpected Query Result Working with Dates in a Microsoft Access 2013 Web App
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.
Capture1.PNG
Capture2.PNG
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.
Capture1.PNG
Capture2.PNG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The second pair of eyes, you know.
/gustav
/gustav
ASKER
Indeed I do. Thank you again.
ASKER