Jan 09 2022 01:01 PM
Funktion in a query: Minutes: DateDiff("n",[TimeIn],[TimeOut])
Dont work and I can really not see whats wrong.
Any sugestions?
Jan 09 2022 01:04 PM
@ToreSweden What does it mean to say "Don't work"?
What DOES happen? An error? The wrong result? Nothing?
We can't help unless we know what is wrong.
Jan 09 2022 01:10 PM
Jan 09 2022 03:11 PM
That syntax itself appears to be valid, so there are a couple of additional things to verify.
First, I believe the delimiter should be the same in both versions, i.e. "n"
However, it may be that in your version it could be the single quote, 'n'
That seems unlikely, but we ought to check every possibility.
The more likely problem, though is how it is used in the query. Can you open the query in SQL View and copy the entire SQL statement and paste it here?
Jan 09 2022 03:17 PM
Jan 09 2022 03:31 PM
Jan 09 2022 03:36 PM
Jan 09 2022 04:01 PM