I just tried the last query in another form, using a direct comparison
instead of the DateDiff function. Same error.

SELECT Stvoreni_Convert.DatumStvoreni, CDate([DatumStvoreni]) AS Rozdil,
Stvoreni_Convert.AkcesPodrobnostiAutoID INTO STV
FROM Stvoreni_Convert
WHERE (((CDate([DatumStvoreni]))CDate([From date])));

Pete



"Tom Lake" píse v diskusním príspevku
...

"Petr Danes" wrote in message
...
I have a set of queries that generate dates and want to use DateDiff to
select those records with certain dates are greater than others. The
following clause keeps giving me an incompatible data type error:

WHERE DateDiff('d',[From date],[DatumStvoreni])0

I have the exact expression in the SELECT clause and it show positive and
negative integers just fine, but when I add this test, I get the error.
There are no bad values in the dataset, I've looked, and when I export
the DateDiff column to a temp table and run a query on that, it works
fine. Only when I use the test directly with the DateDiff function does
it bomb. I also tried putting CDate() around the field expressions and it
didn't help.

I get an error when I use single quotes. I have to use this:

DateDiff("d",[From date],[DatumStvoreni])

The whole expression I tried was this:

WHERE (DateDiff("d",[From date],[DatumStvoreni])0)

Tom Lake