Date as a Variable in load script

[pbriggs11]

Hi All,

Recently moved over from Qlikview to QlikSense Cloud and running across a weird issue when setting a variable using a date.  When I run the script below, it does not filter out the data to pull records prior to 12/31/23.  When I remove the variable and use a where clause with '12/31/23', the records are pulled properly.  Am I missing something simple?

-----------------------------------------------------------------------------
Let vHistoricalDate = '12/31/23';

PAYROLLBATCH_EMPLOYEE_HISTORICAL:
LOAD
*,
'Historical Load' as Load_Source
Resident Pre_PAYROLLBATCH_EMPLOYEE_Historical
Where BatchInvoiceDate <= $(vHistoricalDate);

---------------------------------------------------------------------------------

[Antoine04 · Accepted solution]

Maybe try like this, with single ' :

Where BatchInvoiceDate <= '$(vHistoricalDate)';

Let me know if it works ?

Regards

Antoine

[pbriggs11]

That did the trick, thank you Antoine!