Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try adding quotes around variables
WHERE
TRN_DATE > '$(vBeginningLastExecution)' and
TRN_DATE <= '$(vBeginningNewExecution)';
Try adding quotes around variables
WHERE
TRN_DATE > '$(vBeginningLastExecution)' and
TRN_DATE <= '$(vBeginningNewExecution)';