# Show Sales for This Month Only in Stock Management App

**URL:** <https://community.glideapps.com/t/show-sales-for-this-month-only-in-stock-management-app/83635>\
**Category:** Ask for Help\
**Created:** [August 3, 2025, 9:10pm UTC](https://community.glideapps.com/t/show-sales-for-this-month-only-in-stock-management-app/83635 "2025-08-03T21:10:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Zindagi\_Doerga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zindagi_doerga/32/90948_2.png) [@Zindagi\_Doerga](https://community.glideapps.com/u/Zindagi_Doerga)\
**Post date:** [August 3, 2025, 9:10pm UTC](https://community.glideapps.com/t/show-sales-for-this-month-only-in-stock-management-app/83635/1 "2025-08-03T21:10:57Z")

</div>

Hi everyone,

I’ve built a stock management app in Glide where customers can view how many bikes they’ve sold. Right now, I can show the **total number of bikes ever sold** using a rollup column.

However, I’d like to display **only the number of bikes sold in the current month** , or example: “Bikes sold in July”.

Does anyone know the best way to achieve this in Glide?

I imagine it involves filtering the sales by date, but I’m unsure how to do that within a rollup or relation that only includes **sales from the current month**.

Any help or step-by-step advice would be greatly appreciated!

Thanks in advance 🙏

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [August 3, 2025, 9:16pm UTC](https://community.glideapps.com/t/show-sales-for-this-month-only-in-stock-management-app/83635/2 "2025-08-03T21:16:23Z")

</div>

If you create a relation or query that only returns data for a specific date range, then your rollup can use the relation or query instead of pointing to the entire table

---

<div class="post-metadata">

**Author:** ![Zindagi\_Doerga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zindagi_doerga/32/90948_2.png) [@Zindagi\_Doerga](https://community.glideapps.com/u/Zindagi_Doerga)\
**Post date:** [August 4, 2025, 5:54am UTC](https://community.glideapps.com/t/show-sales-for-this-month-only-in-stock-management-app/83635/3 "2025-08-04T05:54:21Z")

</div>

Thanks! That makes sense.

But my issue is: in the **Query column** , there’s no option to filter by something like “this month” dynamically. It only lets me set fixed values like “August” or “2025”.

So how can I make sure the query or relation automatically updates based on the current month, without having to manually adjust it each time?

Is there a workaround for that?

---

<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:** [August 4, 2025, 6:10am UTC](https://community.glideapps.com/t/show-sales-for-this-month-only-in-stock-management-app/83635/4 "2025-08-04T06:10:43Z")

</div>

Create a math column in your User Profile table using the following formula:

```bash
Now
- Day(Now)
- Hour(Now)/24
- Minute(Now)/1440
- Second(Now)/86400
+ 1

```

In the above, `Now` should be replaced with the special “Now” value, which provides the current date & time.

You can then reference that column in your query filter.

 ![CleanShot 2025-08-04 at 14.10.24@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/4/745f8f9e09aeede55833282049c93ea9ec32ac08.png)