# Sort by Year

**URL:** https://community.glideapps.com/t/sort-by-year/25924
**Category:** Ask for Help
**Created:** [April 23, 2021, 2:03am UTC](https://community.glideapps.com/t/sort-by-year/25924 "2021-04-23T02:03:11Z")
**Posts on this page:** 4
**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: [April 23, 2021, 2:03am UTC](https://community.glideapps.com/t/sort-by-year/25924/1 "2021-04-23T02:03:11Z")

</div>

Hi there.  
I have been collecting data on my app for the year by date, etc.  
I want to keep using the app without it resetting but want to allow user to only see data from the current year as default or they can see a past year of data, by using a choice menu ideally. NOt past 365 days but calendar year Jan 1 - 12/31

I can’t figure out how to do that within the app. Any suggestions?

Thanks!

---

<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 23, 2021, 2:23am UTC](https://community.glideapps.com/t/sort-by-year/25924/2 "2021-04-23T02:23:47Z")

</div>

Use a math column to extract just the year from the date (`Year(date)`), and use that column as a filter.

---

<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: [April 25, 2021, 4:57pm UTC](https://community.glideapps.com/t/sort-by-year/25924/3 "2021-04-25T16:57:25Z")

</div>

> [@Darren\_Murphy](#):
>
> ( `Year(date)` ),

Thank you! Now just trying to figure out how to integrate it into my app and on which sheet!

---

<div class="post-metadata">

### Author: ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/sort-by-year/25924/4 "2024-01-17T16:52:28Z")

</div>