>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

Do you mean business days? Otherwise, ldstop - 5 would work.