so when im using the between a daterange parameter for a query, how do include the start date as well as the end date?
-
-
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)> -
in sql as well as the access query,
here is what i am using currently
is there a way to add -1 to the start date and +1 to the end date? would that be the proper logic.Code:Between Nz([Forms]![frm_Reporting]![begin],#1/1/1900#) And Nz([Forms]![frm_Reporting]![end],#12/31/9999#)
Comment
-
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"
Nic;o)Comment
Comment