weird sql result with date

[Florian Bogeschdorfer]

V4MD1.1 client

 

Hi! I have this script:

 

z=valselectreturncursor("SELECT Z_DAY_KD_ID,geburtsdatum FROM
Z_DAY,KUNDENTable WHERE Z_DAY_KD_ID<>0 AND Z_DAY_KD_ID=KD_ID AND
geburtsdatum<=26.08.1946 AND geburtsdatum>=27.08.1965")

 

these are the results:

 

put valgetcurrentrecord(z)

-- [#Z_DAY_KD_ID: 4509, #geburtsdatum: "17.09.1983"]

 

put valcursorreccount(z)

-- 70904

 

Infact I would expect 0 results. Is my sql wrong?

 

Tia,

 

Florian