# Displaying active records over time

**URL:** <https://community.glideapps.com/t/displaying-active-records-over-time/25358>\
**Category:** Ask for Help\
**Created:** [April 9, 2021, 5:21pm UTC](https://community.glideapps.com/t/displaying-active-records-over-time/25358 "2021-04-09T17:21:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Food2Soil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/food2soil/32/659_2.png) [@Food2Soil](https://community.glideapps.com/u/Food2Soil)\
**Post date:** [April 9, 2021, 5:21pm UTC](https://community.glideapps.com/t/displaying-active-records-over-time/25358/1 "2021-04-09T17:21:33Z")

</div>

Hello Gliders,  
So I have a spreadsheet which shows subscribers start date and end date (if they cancelled subscription). I want to build a report which will show all active subscribers at any given date. Has someone done this already and can you point me to resources?

I know it will take some tinkering around with the google sheet and some cleverness in the data editor. Any help or insights are appreciated.

Thankyou very much in advance.  
-Sarah

---

<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:** [April 9, 2021, 5:41pm UTC](https://community.glideapps.com/t/displaying-active-records-over-time/25358/2 "2021-04-09T17:41:06Z")

</div>

No tinkering required in the Google Sheet.  
Let’s say you have 3 columns:

- Start Date: Subscription start date
- End Date: Subscription end date
- Date: the date you’re interested in

In the Glide Data Editor, create an if-then-else column:

- If Start Date is after Date, then false
- If End Date is empty, then true
- If End Date is before Date, then false

The rows that have true in that column will be the ones that were active as of “Date”