# Select a date range
**URL:** https://community.glideapps.com/t/select-a-date-range/19096
**Category:** Ask for Help
**Created:** [November 29, 2020, 7:12am UTC](https://community.glideapps.com/t/select-a-date-range/19096 "2020-11-29T07:12:30Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@Maryth\_R](https://community.glideapps.com/u/Maryth_R)
#### Post date: [November 29, 2020, 7:12am UTC](https://community.glideapps.com/t/select-a-date-range/19096/1 "2020-11-29T07:12:30Z")
Is there a way to select a date range within the calendar or date column to calculate spending within that date range?
For example, lets say that I have an inline list with two years of spending data. I check-marked each day that I used uber as my transportation because I want to know how much I have been spending on uber services at any given time (date range).
Lets say I want to know how much I spent on uber from January 1 to January 14 of 2019. i want to be able to easily choose the desired date range. Then I want to display my desired date range as an inline list.
Each uber ride costs me the same amount because it is the exact same route every time I use it (lets say $35). So each checkmark equals $35.
I would like to calculate the total amount spent from a chosen start date to end date.
Thank you.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [November 29, 2020, 7:48am UTC](https://community.glideapps.com/t/select-a-date-range/19096/2 "2020-11-29T07:48:29Z")
Sounds like the predicament I’m in. I haven’t found a good way to do this entirely within glide. Being able to add conditions to a relation so we can perform a rollup would be ideal.
> [@Conditional Relations](https://community.glideapps.com/t/conditional-relations/13818):
>
> I know myself and others have made this case before, but I’d like to mention it again. I think it would be hugely benificial to be able to apply IF conditions within Relation settings. My use case for this is to get the unpaid dollar amount from unpaid invoices. I have invoices for students that, let’s say, are billed monthly. The user creates the billing period for a particular month, and any lessons that have occured within that billing period are automatically included in that invoice. In…
Never got much traction on this request. I also haven’t formally created a feature request myself, but this one is pretty closely related.
[https://features.staging.glideapp.io/dl/ewAiAHQAIgA6ADAALAAiAHMAIgA6ACIAYwBsAGEAcwBzAC0ARgBlAGEAdAB1AHIAZQBzACIALAAiAHIAIgA6ACIAOQBhAGUAMgAzADAAMwBmAC0AZgA5ADUANQAtADQAOQBjAGIALQBiADEAOAA2AC0AZAA3ADMANgA0ADMANQBmADcAOQAxAGEAIgAsACIAbgAiADoAIgAyACAAdgBvAHQAZQBzACIAfQA%3D](https://features.staging.glideapp.io/dl/ewAiAHQAIgA6ADAALAAiAHMAIgA6ACIAYwBsAGEAcwBzAC0ARgBlAGEAdAB1AHIAZQBzACIALAAiAHIAIgA6ACIAOQBhAGUAMgAzADAAMwBmAC0AZgA5ADUANQAtADQAOQBjAGIALQBiADEAOAA2AC0AZAA3ADMANgA0ADMANQBmADcAOQAxAGEAIgAsACIAbgAiADoAIgAyACAAdgBvAHQAZQBzACIAfQA%3D)