Solved

How to get values Between #Date() hh:nn:ss# and #Date() hh:nn:ss# ?

Posted on 2011-03-13
7
342 Views
Last Modified: 2013-11-05
Hello,
I`m using MSAccess for .net application. Application is storing date records as 13.3.2011 7:06:13.

How can write a query as like this?
Between #Date() hh:nn:ss# and #Date() hh:nn:ss#

Open in new window


Thank you in advance for help to anyone.
0
Comment
Question by:dejandejanovic
  • 3
  • 3
7 Comments
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 35122982
dejandejanovic,

As long as you use Date (which encodes both date and time) as the Access data type for that column, then simply make sure that the parameters you pass in are valid date values.

Patrick
0
 

Author Closing Comment

by:dejandejanovic
ID: 35131631
Thank you for help.
0
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 35131681
dejandejanovic,

I am rather surprised by your choice of grade; a 'C' grade is typically reserved for cases where the answer was vague, and the Expert never replied to reasonable requests for clarification.

If something was missing from my answer, you could have posted a follow-up comment asking for more information, and I would have tried to help you.

If you really felt that my answer was that bad, I would have preferred that you deleted the question.

Patrick
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Author Comment

by:dejandejanovic
ID: 35132393
No, no it was not bad. It was cool tip. I give all the A, but sometimes happened by mistake I click B, or C. I will delete message, just to find how to do it.. Sorry, again.
0
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 35133151
No worries, it looks like the Mods got around to it.

:)

Patrick
0
 

Author Comment

by:dejandejanovic
ID: 35151747
Yes, I have send Request Attention :-)
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

912 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now