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