Formatting DateDiff hh:nn:ss

[jpl458]

I have the following expression in a query in the QBE grid:

Dur:  Format ( DateDiff ("s", [TimeValue(dteCreated]), [TimeValue(dteModified]),  hh:nn:ss" ) AS HH_NN_SS

Trying to calc the duration between 2 times;

Get this error

It must be something I am overlooking, but I can't see it.

 

[theDBguy]

Did you forget the opening quotes for the second Format argument?

Also, don't think you need the "AS" part.

 

[plog]

4 left parenthesis, 3 right.

 

[ebs17]

The process is unclear. Seconds (from the difference) cannot be converted directly into the format used.

Format(dteModified - dteCreated, "hh:nn:ss")

... shows times less than 24 hours.

 

[theDBguy]

The process is unclear. Seconds (from the difference) cannot be converted directly into the format used.

Format(dteModified - dteCreated, "hh:nn:ss")

... shows times less than 24 hours.

I agree. Perhaps the OP is trying to use something like this.

Date/Time: Calculate differences in time

 

[ebs17]

... whereby the question arises why one should take a detour via seconds if one wants to have an entry in hh:nn:ss.