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.

Not really sure about that business process of yours.

But how about:

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

thank you very much, helpful :slight_smile: