Error in SQL query containing Dates when invalid date is entered [resolved]

[DKasler]

ok i have an SQL statement that generates an error if a non-existant date (ie. 2/30/2005) is entered in to the field text2

sSQL = "select patdob,insurance,vaccine,Dose,dov,type,datediff('m',patdob,dov),vaccine from vfcrec Where type='" & Combo1.Text & "' and dov between #" & Text1.Text & "# and #" & Text2.Text & "# and vaccine= '" & DBCombo1.Text & "' order by datediff('m',patdob,dov)asc ;"

Is there any sort of statment like notdate or something I can use to tell the system that if the date can not exist on a calander to ignore the value?

thanks tons =)