# SETFILTER DATE

**URL:** <https://www.dynamicsuser.net/t/setfilter-date/62068>\
**Category:** Developers Forum\
**Created:** [November 23, 2016, 8:23am UTC](https://www.dynamicsuser.net/t/setfilter-date/62068 "2016-11-23T08:23:40Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![AMoussaoui](https://avatars.discourse-cdn.com/v4/letter/a/9e8a1a/32.png) [@AMoussaoui](https://www.dynamicsuser.net/u/AMoussaoui)\
**Post date:** [November 23, 2016, 8:23am UTC](https://www.dynamicsuser.net/t/setfilter-date/62068/1 "2016-11-23T08:23:40Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![admin1](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/admin1/32/7476_2.png) [@admin1](https://www.dynamicsuser.net/u/admin1)\
**Post date:** [November 23, 2016, 8:55am UTC](https://www.dynamicsuser.net/t/setfilter-date/62068/2 "2016-11-23T08:55:09Z")

</div>

Not really sure about that business process of yours.

But how about:

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

---

<div class="post-metadata">

**Author:** ![AMoussaoui](https://avatars.discourse-cdn.com/v4/letter/a/9e8a1a/32.png) [@AMoussaoui](https://www.dynamicsuser.net/u/AMoussaoui)\
**Post date:** [November 23, 2016, 10:54am UTC](https://www.dynamicsuser.net/t/setfilter-date/62068/3 "2016-11-23T10:54:38Z")

</div>

thank you very much, helpful 🙂
