Solved

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

Posted on 2011-03-13
7
369 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA 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…

751 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