Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2011-03-13
7
Medium Priority
?
380 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 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
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…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

705 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