# How to specify date range **URL:** \ **Category:** Ask for Help\ **Created:** [June 30, 2020, 3:42pm UTC](https://community.glideapps.com/t/how-to-specify-date-range/11737 "2020-06-30T15:42:10Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![aha\_education](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aha_education/32/6343_2.png) [@aha\_education](https://community.glideapps.com/u/aha_education)\ **Post date:** [June 30, 2020, 3:42pm UTC](https://community.glideapps.com/t/how-to-specify-date-range/11737/1 "2020-06-30T15:42:10Z")
Hi In my list item how do I specify a date range. As of now I can filter by no, today, before eor after… But I want to filter let us say from June 1st to June 30th items. How do I do that? ---
**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:** [June 30, 2020, 4:24pm UTC](https://community.glideapps.com/t/how-to-specify-date-range/11737/2 "2020-06-30T16:24:41Z")
As of now I don’t think there’s an easy way to do that. A workaround would be assigning 365/366 numbers to each specific day, then do a lookup on two user-specific input columns, which hold those “June 1st” and “June 30th” to return numerical values,. Finally, your inline list will be filtered based on those numerical values. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [June 30, 2020, 5:12pm UTC](https://community.glideapps.com/t/how-to-specify-date-range/11737/3 "2020-06-30T17:12:18Z")
I’ve tried too, no easy solution. I also wanted to filter/alter visibility based on date comparisons to other dates…doesn’t exist yet. Only can compare to on/before/after/within TODAY or NOW…not specific dates. ---
**Author:** ![Daniel\_Canup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_canup/32/32850_2.png) [@Daniel\_Canup](https://community.glideapps.com/u/Daniel_Canup)\ **Post date:** [June 29, 2021, 6:55pm UTC](https://community.glideapps.com/t/how-to-specify-date-range/11737/4 "2021-06-29T18:55:46Z")
What would this look like from a backend perspective @ThinhDinh? ---
**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:** [June 29, 2021, 11:40pm UTC](https://community.glideapps.com/t/how-to-specify-date-range/11737/5 "2021-06-29T23:40:35Z")
Hi Dan, if you’re specifying the date only and don’t want to include the year then I can’t think of a straightforward way. If you have the year in as well, as of now I think the best way is to use a custom filter with 2 user-specific components, one for the start date and one for the end date. Then filter your inline list by date is on or after start date and date is on ore before end date. These must be done on a details view. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [June 29, 2021, 11:45pm UTC](https://community.glideapps.com/t/how-to-specify-date-range/11737/6 "2021-06-29T23:45:02Z")
Extract month number , multiple by 100… add a day number … now you have a number to do filter. ---
**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:** [June 29, 2021, 11:51pm UTC](https://community.glideapps.com/t/how-to-specify-date-range/11737/7 "2021-06-29T23:51:08Z")
But we don’t have a good way for people to choose the date only part for the start and end, or do we? ---
**Author:** ![hisashi.fujita](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hisashi.fujita/32/17088_2.png) [@hisashi.fujita](https://community.glideapps.com/u/hisashi.fujita)\ **Post date:** [June 30, 2021, 9:12am UTC](https://community.glideapps.com/t/how-to-specify-date-range/11737/8 "2021-06-30T09:12:56Z")
★ Create Single Value columns for May 31st and July 1 st ★ If May 31st or later is True in the If → Then → Else column: “check A” ★ If → Then → Else column, set before July 1 st as True: “checkB” ★ Specify check A is True and check B is True in Filter Is it possible to specify the date range from June 1st to June 30th with this? ---
**Author:** ![Daniel\_Canup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_canup/32/32850_2.png) [@Daniel\_Canup](https://community.glideapps.com/u/Daniel_Canup)\ **Post date:** [August 25, 2021, 12:00am UTC](https://community.glideapps.com/t/how-to-specify-date-range/11737/9 "2021-08-25T00:00:56Z")
I too would like to know this. ---
**Author:** ![hisashi.fujita](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hisashi.fujita/32/17088_2.png) [@hisashi.fujita](https://community.glideapps.com/u/hisashi.fujita)\ **Post date:** [August 25, 2021, 2:01am UTC](https://community.glideapps.com/t/how-to-specify-date-range/11737/10 "2021-08-25T02:01:19Z")
How about specifying the period range of the list item in this way? You can copy the app. > **[date range](https://date-range.glideapp.io/)** ---
**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 25, 2021, 2:24am UTC](https://community.glideapps.com/t/how-to-specify-date-range/11737/11 "2021-08-25T02:24:53Z")
hmm, maybe I’m missing something here. Filtering by a date range is trivial - can somebody point out a specific use case where it isn’t? ---
**Author:** ![hisashi.fujita](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hisashi.fujita/32/17088_2.png) [@hisashi.fujita](https://community.glideapps.com/u/hisashi.fujita)\ **Post date:** [August 25, 2021, 2:34am UTC](https://community.glideapps.com/t/how-to-specify-date-range/11737/12 "2021-08-25T02:34:00Z")
The purpose of this topic is “I want to filter items from June 1st to June 30th.” “Filtering by date range is easy” This is really awesome. Would you please share that method? ---
**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 25, 2021, 2:44am UTC](https://community.glideapps.com/t/how-to-specify-date-range/11737/13 "2021-08-25T02:44:10Z")
The exact method can vary depending on the specific use case and how the data is structured, but it’s usually something along the lines of: - Two date picker components to collect the start & end dates, which are stored in User Specific Columns - A pair of single value or lookup columns to apply the selected dates to all rows in the source data table - An if-then-else column to identify the qualifying rows, which is then used as a filter. ---
**Author:** ![hisashi.fujita](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hisashi.fujita/32/17088_2.png) [@hisashi.fujita](https://community.glideapps.com/u/hisashi.fujita)\ **Post date:** [August 25, 2021, 2:49am UTC](https://community.glideapps.com/t/how-to-specify-date-range/11737/14 "2021-08-25T02:49:26Z")
OK, I’ve also searched for an easier way and found a style similar to what you pointed out, so I modified the app I introduced. I removed the check items on the glide table and made it a simpler structure. ![123](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f587324e27125cd6d4f6ddd678eeeec7c5b51013.png) ---
**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 25, 2021, 3:17am UTC](https://community.glideapps.com/t/how-to-specify-date-range/11737/15 "2021-08-25T03:17:28Z")
Yes, that’s fine for simple use cases.