>>>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
>>
>>Don't use SET FILTER, use SQL Select or something else.
>
>
>Thanks
>
>Thanks I eventually did it with
>
>SET FILTER TO day(podtime)=11 AND MONTH(podtime)=5 AND YEAR(podtime)=2016
>
>Thanks
>
>Colin

SET FILTER uses the same optimization that SQL uses - except that SQL can optimize across multiple tables at once.

SET FILTER TO podtime = date(2016,5,11) will work if podtime is a date. If you also have an index on podtime, it will optimize.