select datediff(...) as intDate??

[farracer]

Is it possible to do something like "SELECT datediff(day, '1900.1.1', '1900.1.2' ) as intDate"??

Atm I'm getting an unexpected end of statement error

thx for help
farracer

[Gord Thompson]

I just tested

SELECT DateDiff('d', DateField1, DateField2) AS intDate FROM DateTest

under UCanAccess 2.0.9.4 and it worked fine for me.

[farracer]

seem to work now....no idea what i did before.

thx anyway:D