CreateODBCDateTime and Eurodate problem

[tsherr]

I have a database in Access 2000 using a EuroDate format. It works fine in Access, but when I use the CreateODBCDateTime so that I can run a Select Query between two dates, CF switches the day and month, so a date of Jan, 12, 2002 (12/02/2002) gets switched to Dec 2, 2002 (MM/DD/YYYY.) Is there a way around this?

Thanks,

T

 

[tlhawkins]

hi TSher,

If I were you I would use:

Dateformat(MyDate,"DD/MM/YYYY&quot

You may have to add the Time Stamp as well, if so you can use:
TimeFormat(MyTime,&quot;hh:mm:ss&quot <!--- I think that is correct. you can always output the ODBCDateTime and see exactly what the format is.

I'm sure that between DateFormat and Timeformat you can figure it out.

IF the Time is not necessary, you can fill the spaces with zeros, I'm sure that is what createODBCDate function does.

cheers.