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?
>
--sb--