I have a search page where I need to search between 2 dates. Everything works, except the second search date is not included in the query.
For example. If I search between 10/22/2001 and 10/24/2001. I will get all dates on 10/22 and 10/23, but not 10/24. I know why this is doing this, but I need to include the last date in the search results.
Here's my code:
Line break added to fit code on one pageCode:strdate1 = Request.Form ("strDate1") strdate2 = Request.Form ("strDate2") cmdTemp.CommandText = "SELECT order_id, shopper_id, date_entered, total, status FROM store_receipt WHERE date_entered BETWEEN '" & strDate1 & "' AND '" & strDate2 & "' ORDER BY date_entered DESC"