That sounds good but unfortunately the data access was not done using stored proceures and it would be a MAJOR deal to go back and change that now. I however got this fixed using a technique from another response.
Thanks anyway.
>Dan:
>
>To get around the date problem, I use the following in my select stored procedures. It returns the date as a string without the time part.
>
>convert(char(10), date_field, 101)
>
>When I call the an update stored procedure, its already in the correct format for SQL Server. SQL server ignores the missing time part.
>
>Charlie