OK, then do the following
ldBgnDate = {^2000-01-01} && or the value of some form controls
ldEndDate = {^2000-01-31}
SET FILTER TO between(DateFieldName, ldBgnDate, ldEndDate)
When you want the entire table again --
SET FILTER TO
>Hi Mark
>
>>In Clipper we have the command
>>"set scopetop to " and "set scopebottom to"
>>This was to create a table wiht a portion of the original table.
>
>e.g. use year
> set order to date
> set scopetop to ctod("01/01/2000") && comix command from Foxpro
> set scopebottom to ctod ("31/01/2000")
>
>Now we have a table year with only the month january
>when i need the whole table again we use the command
> set scope to
>and everything is as before
>
>>
>>select datum, periode, &cID from jaar where jaar.datum = dDatum into table SomeTempTable
>
>This command is correct but now i have only a view
>Browse is automatily started i don't need a browse screen
>
>Greetings
> Ben
Mark McCasland
Midlothian, TX USA