Search Between 2 Dates 1

[net123]

I have a btnSearch_Click event in which it searches a DB with all the data that is between the entered date and today's date. Here is my logic:

Dim TodayDT As DateTime
TodayDT = DateTime.Now

...
"AND Convert(char(10),dbo.Table1.ThisDate,101) BETWEEN '" & txtThisDate.Text & "' AND '" & TodayDT.ToString("{0:MM/dd/yyyy}&quot & "' " & _
[/blue]

Nothing returns on the ASP.NET page. Does someone see something wrong in my logic?

 

[chiph]

What happens when you run the query in QueryAnalyzer or the interactive SQL tool that comes with your database?

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first

 

[jzelhart]

"AND Convert(char(10),dbo.Table1.ThisDate,101) BETWEEN '" & txtThisDate.Text & "' AND '" & TodayDT.ToString("{0:MM/dd/yyyy}&quot & "' " & _

I would change this to the following

"AND dbo.Table1.ThisDate BETWEEN Convert(DateTime," & txtThisDate.Text & ",101) AND GETDATE()" & _

It works for me. The way you were doing it, you were comparing the text values instead of the date values.

Hope everyone is having a great day!

Thanks - Jennifer