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?
Well, the error msg saying the syntax is invalid.
Thats it.
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- Really. I am not surprised it is different, but the semi-colon ; definitely does surprise me:
Minutes: DateDiff(;n;,[TimeIn],[TimeOut])- No, its the comma´s, to be changed like: Minutes: DateDiff("n";[TimeIn];[TimeOut])
Tore