Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try
Date#(shift_date)< $(v_Load_Before_date)