Thanks Sergey,
it turns out that my initial error was due to me passing the date in DMY format. I have switched to using the SPT parameter and that works great.
Thanks.
>The date literals can either be represented as strings or numbers. See BOL for details.
>The 22/08/2006 is 22 devided by 8 and devided by 2006 which is equals 0. 0 is base SQL date = 01/01/1900. Try
WHERE edc_dentry = '2006-08-22'
You can also use SPT parameters
>
ldDate = DATE(2006,08,22)
>...
>WHERE edc_dentry = ?ldDate
>
>
>
>>Thanks, initially I had the single quotes around the date time, but got an error about problems converting the character value (or something like that).
>>
>>I have since found that if I just put:
>>
>>
>>WHERE edc_dentry = 22/08/2006
>>
>>
>>I at least get some data (even though the edc_dentry field has a value of 01/01/1900 in it!
>>
>>Is there some better way of passing a date value to SQL Server that won't have the problem of whether using DMY or MDY or YMD format dates?
>>