Consider the following select statement sent from ASP (via the Visual Foxpro ODBC driver) on a table containing a field that stores date values as a string:

strQuery = "SELECT build, CTOD(build) buildasdate FROM project"
SET objRecordSet = objConn.Execute(strQuery)

A sample result set is as follows

build buildasdate
01/01/1998 01/01/1998
01/02/2000 01/02/2000
17/05/2000 NULL

Correct me if I'm wrong but the obvious explanation of the NULL value appearing is that CTOD is interpreting the date string as mm/dd/yy.
Is it possible for CTOD to interpret date strings dd/mm/yy?

I would also be interested to know how CTOD works over ODBC.

Thanks in advance