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

Date Ranges

P: 98
so when im using the between a daterange parameter for a query, how do include the start date as well as the end date?
Feb 3 '10 #1
Share this Question
Share on Google+
3 Replies

Expert 2.5K+
P: 3,532
I'm sorry, but your post is not very clear! Are you asking how to include it in a query or SQL statement, or how to get Access to prompt for it when you run the query, or what?

Linq ;0)>
Feb 3 '10 #2

P: 98
in sql as well as the access query,
here is what i am using currently
Expand|Select|Wrap|Line Numbers
  1. Between Nz([Forms]![frm_Reporting]![begin],#1/1/1900#) And Nz([Forms]![frm_Reporting]![end],#12/31/9999#)
is there a way to add -1 to the start date and +1 to the end date? would that be the proper logic.
Feb 5 '10 #3

Expert 2.5K+
P: 3,072
The BETWEEN operand does include the date FROM and TO by design.
The only problem you can have is with dates including the time, in such a case add to the date start " 00:00" and the date end " 23:59"

Feb 6 '10 #4

Post your reply

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