Mike Yearwood
Toronto, Ontario, Canada
>>>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement