>>>>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.
Thanks for that - thats the answer I manages t wotk out
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing