All Forums Database
gfuller40 24 posts Joined 05/10
01 Aug 2011
Query by date returning error vb.net

I'm trying to run a query from a search form by date and I'm receiving the following error: [Teradata Database] Partial string matching requires character operands.

The code for the search is:

ElseIf OptDate.Checked = True Then
sSQL &= "DATE_SUBMIT Like ('" & txtDateRec1.Text & "%')"
End If

and yes - the data type for the column is "date".

gfuller40 24 posts Joined 05/10
01 Aug 2011

Sorry this is the correct SQL

sSQL &= "DATE_SUBMIT = ('" & txtDateRec.Text & "')"

You must sign in to leave a comment.