# Adding a sell by date filter to inventory app in the order history

**URL:** <https://community.glideapps.com/t/adding-a-sell-by-date-filter-to-inventory-app-in-the-order-history/68507>\
**Category:** Ask for Help\
**Created:** [December 8, 2023, 2:01pm UTC](https://community.glideapps.com/t/adding-a-sell-by-date-filter-to-inventory-app-in-the-order-history/68507 "2023-12-08T14:01:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mohd](https://avatars.discourse-cdn.com/v4/letter/m/57b2e6/32.png) [@Mohd](https://community.glideapps.com/u/Mohd)\
**Post date:** [December 8, 2023, 2:01pm UTC](https://community.glideapps.com/t/adding-a-sell-by-date-filter-to-inventory-app-in-the-order-history/68507/1 "2023-12-08T14:01:04Z")

</div>

Hello everyone,  
hope you’re well,  
Anybody have an idea about how can I add a sale by date filter like sell by date filter like by days or week or month to the inventory app in the order history section

 ![Screen Shot 2023-12-08 at 5.55.49 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/8/a8515ddb8354664365be2012f649eecafe3a578e.png)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 8, 2023, 11:41pm UTC](https://community.glideapps.com/t/adding-a-sell-by-date-filter-to-inventory-app-in-the-order-history/68507/2 "2023-12-08T23:41:20Z")

</div>

You would have to use some math columns/Javascript to convert the timestamp to the corresponding day, week and month format first.

Then use them in the collection’s in-app filter setup.

---

<div class="post-metadata">

**Author:** ![Mohd](https://avatars.discourse-cdn.com/v4/letter/m/57b2e6/32.png) [@Mohd](https://community.glideapps.com/u/Mohd)\
**Post date:** [December 11, 2023, 10:52am UTC](https://community.glideapps.com/t/adding-a-sell-by-date-filter-to-inventory-app-in-the-order-history/68507/3 "2023-12-11T10:52:24Z")

</div>

Thank you man

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 11, 2023, 11:45pm UTC](https://community.glideapps.com/t/adding-a-sell-by-date-filter-to-inventory-app-in-the-order-history/68507/4 "2023-12-11T23:45:50Z")

</div>

Have you been able to solve it? Please let us know if you need more help.

Another thought is to use two user-specific fields to store a start date and end date, and use a query to dynamically let users filter by the range.