Discussion Board for collaboration on QlikView Scripting.
I would like to exclude values in a field that are in the future using a where statement:
SQL SELECT "auf_datum",
bez as Leistungstext,
verkauf_soll as VK_soll,
verkauf_ist as VK_ist,
einkauf_ist as EK_ist,
auf_brutto as EK_soll,
FROM EASY.jleistg where storniert = 0 and optional = 0 and "auf_datum" < (here I would like to load the actual date);
Does anyone know how to read the date in there?
Thank you for your help!
Go to Solution.
Hi Try below
"auf_datum" < replace(cast(curdate() as char(10)), '-', '.');
"auf_datum" < CURRENT_DATE();
Hi Which database you use
FROM EASY.jleistg where storniert = 0 and optional = 0 and "auf_datum" < DATE(CURDATE())
Again no points awarded in this thread.
this one did not work...
Hi can you tell me in which format you have dates?
and is this date field or string?
Thank you for your help
the format is dd.mm.yyyy
Never used such database, but you can use qlikview for this purpose:
where storniert = 0 and optional = 0 and auf_datum < DATE(today())