# Grabbing the first item of each day

**URL:** <https://forum.bubble.io/t/grabbing-the-first-item-of-each-day/147516>\
**Category:** Database\
**Created:** [April 22, 2021, 2:45am UTC](https://forum.bubble.io/t/grabbing-the-first-item-of-each-day/147516 "2021-04-22T02:45:54Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Drahgoone](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/drahgoone/32/29763_2.png) [@Drahgoone](https://forum.bubble.io/u/Drahgoone)\
**Post date:** [April 22, 2021, 2:45am UTC](https://forum.bubble.io/t/grabbing-the-first-item-of-each-day/147516/1 "2021-04-22T02:45:54Z")

</div>

Hello, i’ve become a bit confused with how :grouped by works in regards to getting the first item within a group as a list.

![download](https://us1.discourse-cdn.com/bubble/original/3X/9/2/92dba97c510ceffdf446d3b69ea6842fc5967ca4.png)

![download (1)](https://us1.discourse-cdn.com/bubble/original/3X/b/3/b34c13474eaf703b96aae10eebb96b0566af995b.png)

As you can see from the two top images, I have a list of things that I am grouping up by day, but what I want to do is grab the first item from each day; I tried :sort by but when I attempt to grab the first item its no longer a list, as it should ideally be a list of the first item from each day (or group). Perhaps :grouped by is not the way to go about this… Thank you very much in advance, not entirely sure what the best way to go about this is.