Jump to content
Sign in to follow this  

Remedy ODBC SQl Statement does not work

Recommended Posts


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.


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Create New...