# Date Range in Glide

**URL:** <https://community.glideapps.com/t/date-range-in-glide/21724>\
**Category:** Ask for Help\
**Created:** [January 25, 2021, 6:57pm UTC](https://community.glideapps.com/t/date-range-in-glide/21724 "2021-01-25T18:57:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dmcrabby](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dmcrabby/32/19959_2.png) [@dmcrabby](https://community.glideapps.com/u/dmcrabby)\
**Post date:** [January 25, 2021, 6:57pm UTC](https://community.glideapps.com/t/date-range-in-glide/21724/1 "2021-01-25T18:57:27Z")

</div>

This community has been so supportive and helpful! Thank you!

I am working all in glide and have not had to use any coding outside of my basic html in the rich text fields, or in my spreadsheet. But is there a way in GLIDE, to select a range of dates:  
Last 30 days. Since March 15. in Glide. I have checked all the other posts and don’t see this particularly addressed.

I have contacts from 2016 to now, but would love to have an option in a report screen, where in “this time frame”, these filters are true and display only certain info.

---

<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:** [January 25, 2021, 7:10pm UTC](https://community.glideapps.com/t/date-range-in-glide/21724/2 "2021-01-25T19:10:57Z")

</div>

Sure, there’s a few ways to do that. You could probably have a choice component with different options that will write to a column that you use for your filter to compare the date in the list to the screen value date set by a choice.

Check out this post for some ideas. I haven’t tried using text values from a choice component to set a date, but it might be worth a shot. Or you could use a math column to calculate a number of days from today (might be better if you want the value to automatically update) then use that calculated value for your filter.

> [@Fun with Dates](https://community.glideapps.com/t/fun-with-dates/21684):
>
> I just remembered something from a long time ago. I don’t remember if I had posted about it in this forum or in the old spectrum forum. Can’t find the post in either forum right now. Working on these posts re-triggered this memory. What I had discovered back then is how ridiculously forgiving the calendar layout is. It can take dates in a variety of formats and still determine the correct date to show. But the really cool thing I had discovered is that you can feed it certain types of te…