Hi!

What is wrong with date(nYear, nMonth, nDay) function? You can extract day, month and year values from string using usual VFP string functions, of date format in string is always the same and exact. This way you will never depend on the VFP settings for dates. If you can pass 3 parameters to the query - its even better.

>The following is being done in ASP environment using ADO and Visual Foxpro ODBC Driver so SET DATE cannot be used as a solution to this problem.
>
>I am querying a Foxpro 2.6 table using SELECT CTOD(Field) FROM table. The CTOD function is currently interpreting character dates as yy/mm/dd, however the character field in the table is in dd/mm/yy format. I need to know if it is possible, over VFP ODBC, to make CTOD interpret character dates as dd/mm/yy?
>
>The regional setting of both the server and client is set to Australian.
>I cannot modify the table structure as it is used by an older application that I know little about.
>
>Desperately needing an answer to this one. Any ideas anyone?
>
>Thanks in advance
>
>George