Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 384
  • Last Modified:

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

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
dejandejanovic
Asked:
dejandejanovic
  • 3
  • 3
1 Solution
 
Patrick MatthewsCommented:
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
 
dejandejanovicAuthor Commented:
Thank you for help.
0
 
Patrick MatthewsCommented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
dejandejanovicAuthor Commented:
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
 
Patrick MatthewsCommented:
No worries, it looks like the Mods got around to it.

:)

Patrick
0
 
dejandejanovicAuthor Commented:
Yes, I have send Request Attention :-)
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now