this is my string
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??
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??