I wish all of you a merry christmas and a happy new year.

In EDB Manager works this perfect:
select * from Kontobuchungen where valutadatum <= cast('2008-01-01' as date)

When I try this in code:

......
memo1.Lines.Add('AND (Valutadatum =' +quotedstr('2008-01-01')+')');

Then I get "Expected Date expression but found '2008-01-01'.....

Please help me
Tahnks
Dieter

Dieter

>memo1.Lines.Add('AND (Valutadatum =' DATE  +quotedstr('2008-01-01')+')');

Roy Lambert [Team Elevate]