Forum Discussion
DateDiff issue
Funktion in a query: Minutes: DateDiff("n",[TimeIn],[TimeOut])
Dont work and I can really not see whats wrong.
Any sugestions?
9 Replies
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.
- Well, the error msg saying the syntax is invalid.
Thats it.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?
