how do i pass a date parameter the data type of the field in the database is date time<BR><BR>set myfirstparam12=cmd.CreateParameter("givendate",adD ate,adParaminput, 7)<BR>cmd.parameters.append myfirstparam12 <BR><BR>cmd("givendate")="21-apr-1999"<BR>cmd.execute<BR>&#037;&#062;<BR><BR>i tried the above thing out <BR>but it does not seem to work<BR>