# Filtering based on Time **URL:** \ **Category:** Ask for Help\ **Created:** [July 2, 2024, 8:31pm UTC](https://community.glideapps.com/t/filtering-based-on-time/74570 "2024-07-02T20:31:14Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![o\_te\_hennepe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/o_te_hennepe/32/62267_2.png) [@o\_te\_hennepe](https://community.glideapps.com/u/o_te_hennepe)\ **Post date:** [July 2, 2024, 8:31pm UTC](https://community.glideapps.com/t/filtering-based-on-time/74570/1 "2024-07-02T20:31:14Z")
Hey all, I’m in the textile business and I use glide to keep everything in 1 spot between my team and the suppliers. I’m currently working on a homepage where I want to show a container that displays upcoming deadlines. In the container I have a table that shows all the orders. Now I want to be able to filter these orders and only make them show if the ETD is within the next 2 weeks for example. Anyone knows how to do this? ---
**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:** [July 2, 2024, 11:15pm UTC](https://community.glideapps.com/t/filtering-based-on-time/74570/2 "2024-07-02T23:15:42Z")
- In your table, create a Math column that has the formula: `N+14` with N being “Now” value. - You now have the value of “2 weeks later”. Filter the collection so that the ETD value is on or before the “2 weeks later” value, and after now. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [July 9, 2024, 11:16pm UTC](https://community.glideapps.com/t/filtering-based-on-time/74570/3 "2024-07-09T23:16:15Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.