Remedy ODBC SQl Statement does not work

[Whenever]

Hello,

i am trying to execute this SQL statement but it won't work:

SELECT sum(GIEIST) FROM WOCapacity WHERE (WorkCenter<60) AND (GIEIST>0) AND DATEADD(day,convert(int,datum+7200)/86400,'1 Jan 1970') >= DATEADD(wk, DATEDIFF(wk,0,getdate()), 0) AND DATEADD(day,convert(int,datum+7200)/86400,'1 Jan 1970') <= GETDATE()-1

I get the following error message via error handler: 

"Expected lexical element not found: =, <>, <, <=, >, or >="

I hope you can help me, thank you.

 

[JLogan3o13]

How about showing your code, so we can see just what you're doing? "trying to execute this SQL statement" doesn't tell us a lot.

Edited May 12, 2014 by JLogan3o13