Solved

Unexpected Query Result Working with Dates in a Microsoft Access 2013 Web App

Posted on 2014-11-14
4
211 Views
Last Modified: 2014-11-14
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
Comment
Question by:penlandt
  • 2
  • 2
4 Comments
 
LVL 50

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 40443686
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
 
LVL 1

Author Closing Comment

by:penlandt
ID: 40443699
Oh. My. God.  So sorry to bother you with that.  I clearly need a vacation. ;-)
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 40443717
The second pair of eyes, you know.

/gustav
0
 
LVL 1

Author Comment

by:penlandt
ID: 40443724
Indeed I do.  Thank you again.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question