Hi Daniel,

You are the man exec sp_create_translator '2002-05-16' worked.

Thanks
Jim

>>Hello group,
>>
>>I have a procedure:
>>
>>CREATE PROCEDURE sp_create_translator
>>@SchoolYear smalldatetime
>>AS
>>How do I exec this from the sql server query analyzer. Exec '01/01/2002' doesn't work or {01/01/2002 }either.
>>
>>Thanks
>>Jim
>
>It depends on the current format of the datetime "phrase" (for lack of a better term). Remember too that time is part of the value being stored.
>
>If you do a SELECT GETDATE() in QA you can see the pattern that dates are displayed in. For example, I get '2002-05-16 10:05:17.330' (for a SMALLDATETIME, lop off the milliseconds).