I am trying to get a date value to insert into a SQL table. It has to be a date format in the table because it has to be used in a calculation.
The mvpdate field in the SQL table is a date data type.
The datatype on the form is CF_SQL_Date and the form value is
<cfinput type="hidden" name="mvpdate" value="#DateFormat(DateAdd('m', -1, MyDateTime),'YYYYMMDD')#">
I run the form and it gives me this error
August is an invalid date or time string..
<cfqueryparam value="#form.mvpdate#" cfsqltype="CF_SQL_Date"> ,
Is there something else I should us except YYYYMMDD?
Any help is appreciated.