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...

[#2]

But apparently IsDate checks for date formats yyyy-m-d and yyyy/m/d. my format is dd.mm.yyyy.

Thus I get an error.

sorry for being such a pain...

[eduardo_sommer]

This is from the Pervasive manual:

This list shows expressions for January 1, 2003 that evaluate to True (-1) or False (0).

Evaluates to TRUE

IsDate("2003/01/01")

IsDate("01/01/2003")

IsDate("2003-01-01")

IsDate("03-01-01")

IsDate("01-01-2003")

IsDate("01-01-03")

IsDate("2003-1-1")

IsDate("January 01, 2003")

IsDate("01-Jan-03")

IsDate("2003.01.01")

IsDate("01.01.2003")

Evaluates to FALSE

IsDate("010103")

IsDate("January 01 2003")

IsDate("Jan 01 2003")

IsDate("Jan-01-2003")

IsDate("20030101")

IsDate("030101")

Eduardo

[eduardo_sommer]

As you can see, from the manual, yor format is recognized as valid.

Eduardo

[#5]

this is what i get as error message:

SQL##f - SqlState: 37000, ErrorCode: 0, ErrorMsg: [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Syntax Error: SELECT "job_nummer",

    jobnr,

    "datum_auftrag",

    Year ("datum_auftrag") as Jahr,

    Month ("datum_auftrag") as Monat

FROM EASY.job Where ISDATE("datum_auftrag"<< ??? >>)

SQL SELECT "job_nummer",

    jobnr,

    "datum_auftrag",

    Year ("datum_auftrag") as Jahr,

    Month ("datum_auftrag") as Monat

FROM EASY.job Where ISDATE("datum_auftrag")

thanks for investing so much thought eduardo...

[eduardo_sommer]

Hi Jan,

I love these chalenges, hahaha

Let's give a last try: The ODBC can be passing the double quotation marks within the ISDATE function. Try using ISDATE(datum_auftrag) without the quotation marks.

Don't give up!

Eduardo