# Filter information by month
**URL:** https://forum.adalo.com/t/filter-information-by-month/9502
**Category:** Get Help
**Created:** [February 22, 2021, 11:55am UTC](https://forum.adalo.com/t/filter-information-by-month/9502 "2021-02-22T11:55:12Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Paulo](https://forum.adalo.com/u/Paulo)
#### Post date: [February 22, 2021, 11:55am UTC](https://forum.adalo.com/t/filter-information-by-month/9502/1 "2021-02-22T11:55:12Z")
I am developing a cash flow app. It checks how much the store has sold for each product and how many units. the point is that I am not able to filter this information by month. Does anyone know how I can do this?
---
### Author:  [@oceanman](https://forum.adalo.com/u/oceanman)
#### Post date: [February 22, 2021, 9:29pm UTC](https://forum.adalo.com/t/filter-information-by-month/9502/2 "2021-02-22T21:29:54Z")
Yup, this is one of my main issues with Adalo’s built in features and DB. It doesn’t easily allow for this, even though monthly filters would be very useful.
Here’s where you can vote on the feature request:
> **[Month & Year functions | Voters | Adalo](https://adalo.canny.io/feature-requests/p/month-year-functions)**
---
### Author:  [@theadaloguy](https://forum.adalo.com/u/theadaloguy)
#### Post date: [February 23, 2021, 8:00am UTC](https://forum.adalo.com/t/filter-information-by-month/9502/3 "2021-02-23T08:00:06Z")
Create a month collection on the database with a start date and end date. Each item or ‘order’ can belong to a month.
To set an order as belonging to a certain month, you need the current month data available on that screen. So for example you could have something like this-
START ORDER button is a list of months where start date is before today and end date is after today. Therefore on the next screen you will have ‘current month’ available.
Then you can set the relationship, update current order \> month \> current month.
This is how I approach the problem.
---
### Author:  [@system](https://forum.adalo.com/u/system)
#### Post date: [March 5, 2021, 8:00am UTC](https://forum.adalo.com/t/filter-information-by-month/9502/4 "2021-03-05T08:00:52Z")
This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.