Visual FoxPro Insert Into & Date Data Types

So, I’m writing some code to insert fields from a form into a VFP database. At first I had an error return stating that a field that is a Date field does not accept null values.

I then tried to force a value into the field thinking that would take care of the problem, but now I’m receiving a data type mismatched error.

The best I can guess is that since VBScript doesn’t use Data Types the date field isn’t be recognized as a date data type.

So my question is how do I insert a date data type into a VFP database using an ODBC connection? Also Numeric values will probably come in handy as well.

Any help is greatly appreciated.