Can you make the SQL dates DateTime values? Or else when you query explicitly add the conversion to DateTime values in the queries by casting.

+++ Rick ---

>Pick your poison:
>Old odbc driver works with varchar(max) but not date
>New odbc driver works with date but not varchar(max), you have to use Text instead