# Filter Posting Date

**URL:** <https://www.dynamicsuser.net/t/filter-posting-date/63650>\
**Category:** Developers Forum\
**Created:** [June 14, 2017, 12:55pm UTC](https://www.dynamicsuser.net/t/filter-posting-date/63650 "2017-06-14T12:55:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dinh\_Son](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/dinh_son/32/7717_2.png) [@Dinh\_Son](https://www.dynamicsuser.net/u/Dinh_Son)\
**Post date:** [June 14, 2017, 12:55pm UTC](https://www.dynamicsuser.net/t/filter-posting-date/63650/1 "2017-06-14T12:55:56Z")

</div>

Hi Everybody

I want filter the Item of customer buy range Posting Date \>= 30D. And write code but not work

Please help me fix.

Thanks so much.

```auto
SETFILTER("Posting Date", '>=%1', CALCDATE('<CM-1M+1D>',EndingDate));

```

[![](http://imageshack.com/a/img924/6004/Zvr5tq.png)](http://imageshack.com/a/img924/6004/Zvr5tq.png)

---

<div class="post-metadata">

**Author:** ![manjusree](https://avatars.discourse-cdn.com/v4/letter/m/898d66/32.png) [@manjusree](https://www.dynamicsuser.net/u/manjusree)\
**Post date:** [June 14, 2017, 1:31pm UTC](https://www.dynamicsuser.net/t/filter-posting-date/63650/2 "2017-06-14T13:31:35Z")

</div>

Hi,

Please write your code in OnPreDataItem of Item ledger entry

---

<div class="post-metadata">

**Author:** ![Dinh\_Son](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/dinh_son/32/7717_2.png) [@Dinh\_Son](https://www.dynamicsuser.net/u/Dinh_Son)\
**Post date:** [June 14, 2017, 4:19pm UTC](https://www.dynamicsuser.net/t/filter-posting-date/63650/3 "2017-06-14T16:19:57Z")

</div>

Thanks you manjusree. But it’s wrong at here ‘\<=%1’

---

<div class="post-metadata">

**Author:** ![sbhatbng](https://avatars.discourse-cdn.com/v4/letter/s/439d5e/32.png) [@sbhatbng](https://www.dynamicsuser.net/u/sbhatbng)\
**Post date:** [June 14, 2017, 4:35pm UTC](https://www.dynamicsuser.net/t/filter-posting-date/63650/4 "2017-06-14T16:35:35Z")

</div>

Store the calcdate in a variable on predata item and then use the variable in the filter on predata item and it will work.

---

<div class="post-metadata">

**Author:** ![Dinh\_Son](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/dinh_son/32/7717_2.png) [@Dinh\_Son](https://www.dynamicsuser.net/u/Dinh_Son)\
**Post date:** [June 15, 2017, 3:37am UTC](https://www.dynamicsuser.net/t/filter-posting-date/63650/5 "2017-06-15T03:37:02Z")

</div>

Thanks you sbhatbng