SETFILTER DATE

[AMoussaoui]

Hi everyone,

i have a table X and a field in it calls “Preferred pickup date” .

i want to set a filter to select the records from the table where the “Preferred pickup date” > 60 days to Void/Cancel the pickup requests, this is runnung every day, every hour to cancel automatically.

please how can i do this line of code.

[admin1]

Not really sure about that business process of yours.

But how about:

SETFILTER(“Preferred pickup date”,’>%1’,CALCDATE(’-<60D>’,WORKDATE));

[AMoussaoui]

thank you very much, helpful