what is the correct way to pass a d

[ktucci]

what is the correct way to pass a datetime parameter in a sp...this does not work...any suggestions

exec sp_orderstatus voice, new, '12/31/2000', '03/31/2001'

 

[JNC73]

Hi Ktucci,

I always used the format 'mm-dd-yyyy'

and defined the parameter as datetime value.

Then you can use the parameter as a datetime value and this should work fine. At least it did in my situation.

JNC73