Date/Time format with MS Access & CF

[rapcgtiac]

Does anyone know of any workarounds regarding date/time format between MS
Access and ColdFusion?

Right now I have to set a column in my Access database as text for data in it
to be displayed on my web site. When the column is set as date/time I get an
error when trying to display it with CF on my web site. Help!

[OldCFer]

What kind of errors?

[rapcgtiac]

The error is: "Data type mismatch in criteria expression"

I looked up the error explanation in Dreamweaver and this is what it says:

"This error occurs then the server tries to process a page containing an
Insert Record or Update Record server behavior, qand the srver behavior
attempts to set the value of a Date/Time column in a Microsoft Access database
to anempty string ("").
Microsoft Access has strong data typing; it imposes a rigorous set of rules on
given column values. The empty string value in the SQL query cannot be stored
in an Access Date/Time column. Currently, the only know workaround is to avoid
inserting or updating Date/Time columns in Access with empty ("") or with any
other value that does not correspond to the range of values specified for the
data type."

The thing is that I am not inserting nor updating a Date/Time column, but
rather trying to view info from a Date/Time column using CF.