# Date filter to calculate last 30 days data

**URL:** <https://community.glideapps.com/t/date-filter-to-calculate-last-30-days-data/70514>\
**Category:** Ask for Help\
**Created:** [February 5, 2024, 2:39pm UTC](https://community.glideapps.com/t/date-filter-to-calculate-last-30-days-data/70514 "2024-02-05T14:39:32Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [February 5, 2024, 2:39pm UTC](https://community.glideapps.com/t/date-filter-to-calculate-last-30-days-data/70514/1 "2024-02-05T14:39:32Z")

</div>

Hi Guys,

I have got a table which has Invoice value and Date. I know how to get This Month, This year and Date Range values by putting in a Choice value. I need to know how can I get

Last 30 Days — Based on Now

I am using Now Date as baseline.

Could someone help me out with formula to calculate last 30 days based on Now Date?

Thank you guys in advance,

Regards,  
Dilip

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 5, 2024, 2:44pm UTC](https://community.glideapps.com/t/date-filter-to-calculate-last-30-days-data/70514/2 "2024-02-05T14:44:17Z")

</div>

Create a Math column using the formula `Now-30`, where Now is the current date/time.  
This will give you the date 30 days ago.

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [February 5, 2024, 2:47pm UTC](https://community.glideapps.com/t/date-filter-to-calculate-last-30-days-data/70514/3 "2024-02-05T14:47:03Z")

</div>

Now can be a date like 5 Feb 2024?

Or should it be converted to integer?

Regards,  
Dilip

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [February 5, 2024, 2:48pm UTC](https://community.glideapps.com/t/date-filter-to-calculate-last-30-days-data/70514/4 "2024-02-05T14:48:24Z")

</div>

Thank you Darren as always 🙂

---

<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:** [February 6, 2024, 12:24am UTC](https://community.glideapps.com/t/date-filter-to-calculate-last-30-days-data/70514/5 "2024-02-06T00:24:22Z")

</div>

Now is a value that you can reference in a math column.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/b/bb4eabff98798392b1125f122261778b86562813.png)

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [February 6, 2024, 5:12am UTC](https://community.glideapps.com/t/date-filter-to-calculate-last-30-days-data/70514/6 "2024-02-06T05:12:17Z")

</div>

Thank you ThinhDinh, I had got the solution working.

---

<div class="post-metadata">

**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:** [February 13, 2024, 5:12am UTC](https://community.glideapps.com/t/date-filter-to-calculate-last-30-days-data/70514/7 "2024-02-13T05:12:31Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.