Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Where statement

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!

10 Replies
Not applicable
Author

Second one works for me. Thank you very much!