datediff in access 97???

[dan]

I'm trying to add the expression below (as recommended
here) in an aql statement:

SUM(DateDiff("n",TimeArr-TimeDep))/60

However, access 97 doesn't seem to recognise DateDiff.
Can anyone give me an alternative method of creating this
expression in access 97??

Cheers,

Dan.

 

[SA]

Dan:

DateDiff is supported in Access 97. There may be two issues that would
cause A97 not to "recognize" it.

1.) If there is a missing reference in your db (Open a module and from the
Tools->References dialog see if anything is missing.)
2.) Sometimes you simply have to compact the db, which will recompile the
query execution plans internally for it, which will result in Access then
recognizing the built in function.

 

[John Spencer (MVP)]

Sum(DateDiff("n",TimeArr,TimeDep))/60

Note that the minus has been replaced with a comma in the above.