Try this
<cfprocparam type="In" cfsqltype="CF_SQL_TIMESTAMP"
value="#DateFormat(form.txtInvoiceDate, 'dd-mm-yyyy')#"
null="No">
Note:
The MS SQL server datatype DATETIME maps to CF_SQL_TIMESTAMP.
Removed CreateODBCDate function call
Corrected nested quotes in value attribute contents
The dbvarname attribute is no longer supported
You may also try a date format string 'yyyy-mm-dd' or
'mm-dd-yyyy' depending on the configuration of your SQL server
http://msdn.microsoft.com/en-us/library/ms189491.aspx