Search for records having the date and after

Cuttie0506 · #1 (**permalink**) 02-08-06, 22:00

I request the date from my textbox "txtStart".
The date format is "12-Feb-2006"

I want to search records that have the date "12-Feb-2006" or after that date. How do i search for that?

Btw, the date inside my db is a text.

Code:

	If request.form ("txtStart") <> "" Then
		strSentence9 = request.form("txtStart")
	End If

Code:

		sqlString = "Status LIKE ('"& strSentence1 &"%') AND Recipient LIKE ('"& strSentence2 &"%') AND Action_Taken LIKE ('"& strSentence3 &"%') AND Severity LIKE ('"& strSentence4 &"%') AND Week LIKE ('"& strSentence5 &"%') AND Class LIKE ('"& strSentence6 &"%') AND Business_Unit LIKE ('%"& strSentence7 &"%') AND Server_Name LIKE ('%"& strSentence8 &"%') AND DeadLine LIKE ('%"& strSentence9 &"%')"

Thanx

Jelly Link · #2 (**permalink**) 02-15-06, 22:56

deadlineSqlString = "datediff(day,cast('" & strSentence9 & "' as smalldatetime),cast(DeadLine as smalldatetime))>=0"

note : the date must be with the right date format

Internet Services

Web Development

Digital Marketing

Consumer Tech