George,

>local ldStart,ldStop,lcQuery
>
>ldStart = first day to pick {08/21/2004}
>ldStop = 5th day to pick {08/15/2004}
>
>** and it is not the last 5 days in the row from 08/21/2004 to 08/17/2004
>
>lcQuery=Select * from mytable where dDate between ?ldStart and ?ldStop
>
>into mycursorresult
>
>Please fix my query or advise me how to do it
>TIA

If you know the starting point, then the BETWEEN() function should do what you need.
======================================================
Q:
I Know the ldStart date but ldStop could be changed because I wanna select only 5 days not in the row like date()- 1, date() - 2 ....

ldStop is the day number 5 and not last 5 days from today date() for example.

Thanks