# How to find the yesterday's order with a date column

**URL:** <https://community.glideapps.com/t/how-to-find-the-yesterdays-order-with-a-date-column/39501>\
**Category:** Ask for Help\
**Created:** [March 11, 2022, 6:48am UTC](https://community.glideapps.com/t/how-to-find-the-yesterdays-order-with-a-date-column/39501 "2022-03-11T06:48:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [March 11, 2022, 6:48am UTC](https://community.glideapps.com/t/how-to-find-the-yesterdays-order-with-a-date-column/39501/1 "2022-03-11T06:48:57Z")

</div>

I have a date column in my orders table and also the today date.but I need to get the yesterday’s order date.how can I get this?

---

<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:** [March 11, 2022, 11:54pm UTC](https://community.glideapps.com/t/how-to-find-the-yesterdays-order-with-a-date-column/39501/2 "2022-03-11T23:54:45Z")

</div>

Probably you can add a math column, take the “now” value minus 1.

Then filter your orders by order time is within the value you calculated above.