Stored Procedure Null Vlaues

[G.U.R.U Africa]

Hi!

I get an error when a send a null datetime and integer values to a stored procedure.


Error:
Application uses a value of the wrong type for the current operation.

cmdNP_AQUA.Parameters.Append cmdNP_AQUA.CreateParameter("@effective_to", adDate + adEmpty, adParamInput, 8, rsNP_ESERVER("effective_to")))

cmdNP_AQUA.Execute

Is there a way to send null values to a stored procedure?