Searching between dates in ASP/SQL Server

[moospot]

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:

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"

Line break added to fit code on one page

[dhtmlgod]

Try this:

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 '" & DateAdd("d",1,strDate1)& "' AND '" & DateAdd("d",1,strDate2) & "' ORDER BY date_entered DESC"

[moospot]

That was almost it. It only needed to add onto the second date, so here's what I used.

WHERE date_entered BETWEEN '" & strDate1 & "' AND '" & DateAdd("d",1,strDate2) & "' ORDER BY date_entered DESC"

Thanks D!

[dhtmlgod]

No problem, thats what I'm here for.