.Parameters.Append .CreateParameter("@DateFrom", adVarChar, adParamInput, 25, CStr(MyArgs(1)))
.Parameters.Append .CreateParameter("@DateTo", adVarChar, adParamInput, 25, CStr(MyArgs(2)))

'Setup connection details and open connection to dB
Set mycon = New ADODB.Connection
mycon.ConnectionString = "File Name=" & App.Path & UDL_FILENAME
mycon.Open

Set .ActiveConnection = mycon

'Run command
.Execute

no matter how i pass these variables, i am getting the same error.
i mean i tried with the parameter datatype as adDate. no luck