Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello experts
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,
jobnr,
"auf_anzahl",
ltyp,
storniert,
optional,
verkauf_soll as VK_soll,
verkauf_ist as VK_ist,
einkauf_ist as EK_ist,
auf_brutto as EK_soll,
jznr,
lartnr
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!
Hi Try below
"auf_datum" < replace(cast(curdate() as char(10)), '-', '.');
OR
"auf_datum" < CURRENT_DATE();
Regards
ASHFAQ
Hi Which database you use
Regards
ASHFAQ
try Below
SQL SELECT "auf_datum",
bez as Leistungstext,
jobnr,
"auf_anzahl",
ltyp,
storniert,
optional,
verkauf_soll as VK_soll,
verkauf_ist as VK_ist,
einkauf_ist as EK_ist,
auf_brutto as EK_soll,
jznr,
lartnr
FROM EASY.jleistg where storniert = 0 and optional = 0 and "auf_datum" < DATE(CURDATE())
Regards
ASHFAQ
pervasive
this one did not work...
Hi can you tell me in which format you have dates?
and is this date field or string?
Regards
ASHFAQ
Thank you for your help
the format is dd.mm.yyyy
Hi Try below
"auf_datum" < replace(cast(curdate() as char(10)), '-', '.');
OR
"auf_datum" < CURRENT_DATE();
Regards
ASHFAQ
Hi!
Never used such database, but you can use qlikview for this purpose:
load *
where storniert = 0 and optional = 0 and auf_datum < DATE(today())
;
SQL SELECT "auf_datum",
bez as Leistungstext,
jobnr,
"auf_anzahl",
ltyp,
storniert,
optional,
verkauf_soll as VK_soll,
verkauf_ist as VK_ist,
einkauf_ist as EK_ist,
auf_brutto as EK_soll,
jznr,
lartnr
FROM EASY.jleistg