Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

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
0
penlandt
Asked:
penlandt
  • 2
  • 2
1 Solution
 
Gustav BrockCIOCommented:
Here you state End Date:  01/05/2015
However, the screenshot states End Date:  01/05/2014
That may explain what you see.

/gustav
0
 
penlandtAuthor Commented:
Oh. My. God.  So sorry to bother you with that.  I clearly need a vacation. ;-)
0
 
Gustav BrockCIOCommented:
The second pair of eyes, you know.

/gustav
0
 
penlandtAuthor Commented:
Indeed I do.  Thank you again.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now