P
pon
I have Begin and end date as parameters in my query.
The data in the table is crazy Some dates are 03/28/2007 10:30:27 AM and
some are 03/28/2007.
I tried the following:
1.I formated it with the help of expression but the field became text.
2.I created the criteria Between [Begin Date] And DateAdd("d",1,[End Date]).
For the parameter 03/27/2007 and 03/28/2007
the results include 03/27/2007 10:30:27 AM and 03/28/2007 and 03/29/2007
3.I created the criteria as >= [Begin Date] and < [End Date]
For the parameter 03/27/2007 and 03/28/2007
the results include 03/27/2007 10:30:27 AM and 03/28/2007
and they don't include the data which is like 03/28/2007 10:23:25 PM
How can I make this work?
Please help.
The data in the table is crazy Some dates are 03/28/2007 10:30:27 AM and
some are 03/28/2007.
I tried the following:
1.I formated it with the help of expression but the field became text.
2.I created the criteria Between [Begin Date] And DateAdd("d",1,[End Date]).
For the parameter 03/27/2007 and 03/28/2007
the results include 03/27/2007 10:30:27 AM and 03/28/2007 and 03/29/2007
3.I created the criteria as >= [Begin Date] and < [End Date]
For the parameter 03/27/2007 and 03/28/2007
the results include 03/27/2007 10:30:27 AM and 03/28/2007
and they don't include the data which is like 03/28/2007 10:23:25 PM
How can I make this work?
Please help.