Discussion Board for collaboration related to QlikView App Development.
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();
[2 Update with Timestamp\incremental-TStamp-DB-baza2.xlsx]
(ooxml, embedded labels, table is Transactions)
TRN_DATE > $(vBeginningLastExecution) and
TRN_DATE <= $(vBeginningNewExecution);
Do I miss some timestamp# function or sth else?
Try adding quotes around variables
TRN_DATE > '$(vBeginningLastExecution)' and
TRN_DATE <= '$(vBeginningNewExecution)';
View solution in original post