i am using the following date conversion on sql server v.8
SELECT * FROM weeklyMovements WHERE (weekCommencing = CONVERT(datetime, '" & weekStartDay & "'))
(weekCommencing being a smalldatetime field in the database
and weekStartDay being a variable holding a date)
However, I have just transfered the database to sql server v.7
and the date conversion no longer works.
Any suggestions would be appreciated