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?
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?
- I just did find out that in the Swedish version the comma´s is exchanged to semicolon´s
Problem solved.
Thanks anyway.
Tore
- Should also tell that i am using an Swedish version off Access.
But what i can see is the function spelling the same.
