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!
Second one works for me. Thank you very much!