Thanks but it didnt help.

>You should use unambiguous date format
>

>lcDateInd = {^2010.01.01 00:00:00}
>lcDateErk = {^2010.02.01 00:00:00}
>lcDateStor = {^2000.01.01 00:00:00}
>

>
>
>>I use a prg containing only app. 20 select queries.
>>They give the right results except the one I enclosed.
>>It results 0, which obviously false.
>>The interesting thing is that when I make a selection of the
>>code snippet enclosed and click on "Execute selection", it gives the right result.
>>Any idea?
>>
>>

>>lcDateInd = {2010.01.01 00:00:00}
>>lcDateErk = {2010.02.01 00:00:00}
>>lcDateStor = {2000.01.01 00:00:00}
>>
>>
>>SELECT count(bp_eng_uh.engkod) as db;
>>from bp_eng_uh;
>>where bp_eng_uh.alairva >= lcDateInd;
>>AND bp_eng_uh.alairva < lcDateErk;
>>AND bp_eng_uh.stornozva < lcDateStor;
>>into cursor osszesUH
>>
>>