By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 953 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

Date Range

P: 1
I am having difficulty getting a date range in my query that is between [Date} 0:00:00 and [Date] 23:59:00.

I hope this makes sense. THis is the criteria that I need and I am having difficulty writing it. It will be a report that is run daily but will provide tomorrow's information.

Can anyone help with this?
Dec 5 '07 #1
Share this Question
Share on Google+
2 Replies


Nathan H
100+
P: 104
I am having difficulty getting a date range in my query that is between [Date} 0:00:00 and [Date] 23:59:00.

I hope this makes sense. THis is the criteria that I need and I am having difficulty writing it. It will be a report that is run daily but will provide tomorrow's information.

Can anyone help with this?

Try putting this in the criteria of the date field in your query to bring up tomorrow's information:

Date()+1
Dec 5 '07 #2

NeoPa
Expert Mod 15k+
P: 31,661
Do you mean any time in any day, or any time on a specific date?
Either way is quite easy, but it helps to know exactly what the question is.
Dec 11 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.