date conversion

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

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!