Problem with "Where" clause

[#1]

Hello everyone

I have the following code that gives me a problem with the "Where" clause:

SQL SELECT "job_nummer",

    jobnr,

    "datum_auftrag",

    Year ("datum_auftrag") as Jahr,

    Month ("datum_auftrag") as Monat

FROM EASY.job where "datum_auftrag" = date;

With the "Where" clause I would like to exclude entries that do not have a date.

Could someone help me with this?

Thank you very much in advance...

[ashfaq_haseeb]

try below

to load null only

SQL SELECT "job_nummer",

    jobnr,

    "datum_auftrag",

    Year ("datum_auftrag") as Jahr,

    Month ("datum_auftrag") as Monat

FROM EASY.job where  "datum_auftrag" is null;

Update

to exclude null

SQL SELECT "job_nummer",

    jobnr,

    "datum_auftrag",

    Year ("datum_auftrag") as Jahr,

    Month ("datum_auftrag") as Monat

FROM EASY.job where  "datum_auftrag" <> null;

Regards

ASHFAQ

[#3]

Maybe

From EASY.job where "datum_auftrag" = date and "datum_auftrag" <> NULL;

[#4]

Hm, does not work. Does it matter that the field type is DATE? I seem to have a problem with this particular field. the same expression for jobnr works...

[#5]

How is Datum_auftrag formatted? How is Date formatted? Are they the exact same?

[eduardo_sommer]

Or,

Where "datum_auftrag" is not null

Eduardo

[rbecher]

Hi Jan,

try this:

FROM EASY.job where "datum_auftrag" IS NOT NULL;

[Anonymous · Accepted solution]

where "datum_auftrag" is not null

[#9]

seems to be a tricky one. the expression works but does not filter out entries that do not have a date...

[#10]

dd.mm.yyyy

yes, all are the same