Hi All,<BR><BR>I&#039;m having a bit of trouble inserting a string: 16/03/2003<BR>into an sqlserver field with the datatype smalldatetime.<BR><BR>I have tried using FormatDateTime(CDate(StartDate), 2)<BR><BR>I&#039;m using a stored procedure to insert the data. the value that is used within this is declared as:<BR>@activityStartDate smalldatetime<BR><BR>The error I get is:<BR><BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to smalldatetime.<BR><BR>can anyone help please?<BR><BR><BR>Thanks