Compare dates in WHERE clause while loading data from EXCEL

Anonymous — Mon, 22 Dec 2014 13:44:48 GMT

Hi,

I have an error in WHERE clause - when it's commented it works fine. I probably use incorrect date format while comparing these fields. TRN_DATE in xls is stored as e.g. 2014-12-23 14:50:00 .

let vBeginningLastExecution = '2014-12-22 13:00:00';

let vBeginningNewExecution = now();

LOAD TRN_ID,

TRN_DATE,

LOCATION_ID,

CUSTOMER_ID,

STATUS_ID,

TRN_VALUE

FROM

[2 Update with Timestamp\incremental-TStamp-DB-baza2.xlsx]

(ooxml, embedded labels, table is Transactions)

WHERE

TRN_DATE > $(vBeginningLastExecution) and

TRN_DATE <= $(vBeginningNewExecution);

Do I miss some timestamp# function or sth else?

Re: Compare dates in WHERE clause while loading data from EXCEL

anbu1984 — Mon, 22 Dec 2014 13:46:48 GMT

Try adding quotes around variables

WHERE

TRN_DATE > '$(vBeginningLastExecution)' and

TRN_DATE <= '$(vBeginningNewExecution)';

topic Re: Compare dates in WHERE clause while loading data from EXCEL in QlikView

Compare dates in WHERE clause while loading data from EXCEL

Re: Compare dates in WHERE clause while loading data from EXCEL