Andrew
|
| Posted: 07/13/2004, 3:36 PM |
|
I am selecting records between 2 dates. So I created the grid with the search box, added another text field for end date....
THE PROBLEM IS... although the query builder clearly show the less than equal to, it is operating as less than, so range 7/12 through 7/14 shows 7/12 and 7/13 but not the 14th.....as implied the greater than equal to works fine
Can anyone help??!
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 07/13/2004, 4:05 PM |
|
Check your database to make sure that there are no hours+minutes stored with the dates. 7/14 is not equal 7/14 00:01.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
Andrew Reilley
|
| Posted: 07/13/2004, 4:08 PM |
|
You were right Peterr!! Is there an easy way to append the 23.hours and 59 minutes to the end of the url?
|
|
|
|
peterr
Posts: 5971
|
| Posted: 07/13/2004, 5:05 PM |
|
In your ending date paramater try specifying the Paramater Source as "search_parameter_name +1".
Works for me with MS Access.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Andrew
|
| Posted: 07/13/2004, 6:49 PM |
|
 You the man... I never thought it would be that simple..I was all request.querystring + dateadd(d, ha ha ha
|
|
|
|
Andrew
|
| Posted: 07/14/2004, 2:41 PM |
|
Ok...this worked last night..It no longer works...I have spent 3 hours on this trying everything. The where clause (response.write "WHERE:" & Orders.datasource.Where & "<br>") disappears when I put the 1 in after the search parameter. Can you help again?!!
|
|
|
|
peterr
Posts: 5971
|
| Posted: 07/14/2004, 9:13 PM |
|
I'm not sure how I can help this time. It works for me, so I cannot determine what else could happen that would cause trouble. Are you putting "1" or "+1" after the search parameter?
You may try deleting your Page.asp file from your project so that it gets regenerated (but do not delete Page_events.asp).
You can also submit a support request and attach your page to look at.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Andrew
|
| Posted: 07/18/2004, 8:27 AM |
|
Yes..I had the +1. I tried created entirely new pages with no luck. This is too weird. I hate to trouble support with it but I am not sure what else to do. The success of the project depends on reporting  Thanks again for everything Peter
|
|
|
|
