I have created row3.diff (integer field) and try to pass into query like
where tmp.inDate < dateadd(day, ((Integer)globalMap.get("row3.diff")), tmp.outDate)
job cannot run and show error:
syntax error at or near "globalMap"
I have tried to change to
where tmp.inDate < dateadd(day, '"+((Integer)globalMap.get("row3.diff"))+"', tmp.outDate)
nothing works. Can anybody help me how I should modify?
Thank you very much!