topic Re: DATETIME comparison not working in QlikView

DATETIME comparison not working

Anonymous — Fri, 12 Jan 2018 22:52:40 GMT

Does anyone have the proper way to do an easy comparison with my Progress DB's DATETIME? I need to pull anything updated in the "sku-whs-spf" table over the last 2 days.

vStartDate=Date(now()-2, 'DD/MM/YY.ffff')

FROM PUB."sku-whs-spf"

WHERE "LastUpdate" >= '$(vStartDate)';

But all I get is the error

SQL##f - SqlState: S0002, ErrorCode: 4294947291, ErrorMsg: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Table/View/Synonym not found (7519)

SQL SELECT

As if I'm doing an improper comparison, or the field is not there (but it definitely is). I've even tried harcoding my vStartDate

TIA

Re: DATETIME comparison not working

Anil_Babu_Samineni — Sat, 13 Jan 2018 01:02:33 GMT

I think this error to me "There is no file loaded from Source". What source u used for?

Re: DATETIME comparison not working

sunny_talwar — Sat, 13 Jan 2018 01:10:09 GMT

Does it load without the where clause?

FROM PUB."sku-whs-spf"

I am wondering what happens if you remove the two double quotes, does that change anything

FROM PUB.sku-whs-spf

WHERE "LastUpdate" >= '$(vStartDate)

Re: DATETIME comparison not working

Anonymous — Mon, 15 Jan 2018 14:55:03 GMT

I am embarrassed to say you are correct. It does NOT load without the WHERE clause. I spent hours trying to fix this WHERE clause, but the problem was that I broke my CONNECT statements right above. Sorry for wasting everyone's time. Thanks!