ADO & Dates under ms sql


>The regional settings on the Dev machine are set to UK
>The regional settings on the Web Server are set to US

>However, I do not believe this is the cause,
>since we are using Encode/DecodeDate
>to convert the user-entered data into a TDateTime,
>and entering the date in US (mmdd) rather than UK (ddmm)
>fails with a different error (raised before the query is executed).

You message indicates you are presenting the date as yyyymmdd.
SQL server preferred date format is mm/dd/yyyy
Try that

What problems where you having with TdateTime parameters?
TdateTime parameters are generally the easiest way to
handle dates in queries.

Brian Bushay (TeamB)