Select string question.... 1

[savok]

I am trying to select all the records from the db where startdate is greater than the one in the txt box but for some reason it gives me all the dates? heres the code...


DBComm.ActiveConnection = DBConn
DBComm.CommandText = "Select * from Schedule where ScheduleID = " & strID & " and StartDate > " & txtStartDate & " "
DBComm.CommandType = adCmdText


thanks...

 

[bjd4jc]

First off, are you date fields stored as dates or text?

If they are stored as dates, use this instead of what you have.

"Select * from Schedule where ScheduleID = " & strID & " and StartDate >#" & txtStartDate & "#"

 

[savok]

thank you, it worked!