>>* don't put DATE(),DATETIME() WITHIN SELECT, VFP is buggy
>>dToday=DATE()
>
>Yes, correct, when I adapted the SQL to be shown in this message I forgot that part.

Michel.

Now I am curious.

Why you have marked the Sergey's answer as solution,
it is equal to mine ( in reality mine is more rapids ) ?