ODBC Time importing

[thermite]

im having problems importing time and date fields into filemaker from access. they always come out corrupted. Any ideas

[cjaeger]

import them into text fields, the use calcs to turn them into dates.

[VoidState]

You need to put curly brackets round the dates. like this:

"INSERT name, date VALUES 'myname', {10-10-2003}"

Ferg