QVD WHERE clause?

[ianlapid]

I cant seem to get this to work?

LET v_Load_Before_date = Date#('2018-07-02');

temp_shift_duration:

LOAD

    batch_id,

    shift_date

FROM [$(vLibPath)$(vQVD_Name).qvd](qvd)

WHERE shift_date < $(v_Load_Before_date);

I suspect this: shift_date < $(v_Load_Before_date), doesn't really work?

Thank you in advance!

[francescoreggia]

Try

Date#(shift_date)< $(v_Load_Before_date)