Invalid Date Error

jnash

Well-known member
Joined
Oct 20, 2006
Messages
111
Programming Experience
Beginner
this is my string

VB.NET:
cmd.CommandText = "INSERT tblMember (firstName, surName, DOB, Address1, Address2, Address3, PostCode ) VALUES ('jon', 'biggles', 1983-12-23, '34','Millers Lane', 'somewhere','N21 9HN')"


im recieveing this error? really baffled theres no help on this error!

#22007Incorrect date value: '1943' for column 'DOB' at row 1


i havent put 1943 anywhere??
 
Back
Top