>>>>>>I am trying in the command box to set a filter to records with podtime(date time expression) = today
>>>>>>
>>>>>>How do I do this
>>>>>>
>>>>>>Thanks
>>>>>
>>>>>
>>>>>

>>>>>SET FILTER TO TTOD(podtime) = DATE()
>>>>>

>>>>>
>>>>>?
>>>>
>>>>Thanks I eventually did it with
>>>>
>>>>SET FILTER TO day(podtime)=11 AND MONTH(podtime)=5 AND YEAR(podtime)=2016
>>>>
>>>>Thanks
>>>>
>>>>Colin
>>>
>>>That's a terrible solution. Why don't you use Borislav's solution?
>>
>>It works - how can it be terrible?
>>
>>Thanks
>
>As stated by others, it's not a matter of getting the right answer -- your solution will yield the correct result, as would Borislav's. The difference is likely to occur when you use larger datasets. On a related note, a filtered table might be relatively "straight forward" approach and seems reasonable enough solution (rather than generating a separate cursor through a SQL SELECT, which would seem more "complicated" as it involves a separate table), but you might run into performance issues if you happen to have traverse through the list in something than a straight beginning to end scan (i.e. you scan backwards and forwards through the result).

Thanks I appreciate you answer - it was a large dataset but I only needed to browse the file so it worked fine - Borislavs solution would be used if this were to be be required within a program