[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

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

Posted on 2011-03-13
7
Medium Priority
?
386 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
6 Comments
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 2000 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 93

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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 

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 93

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Implementing simple internal controls in the Microsoft Access application.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

608 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