# Get historical data created between 8am - 10am **URL:** \ **Category:** Database\ **Created:** [May 13, 2020, 11:12pm UTC](https://forum.bubble.io/t/get-historical-data-created-between-8am-10am/91621 "2020-05-13T23:12:46Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![alejandrowunderlich](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/alejandrowunderlich/32/97601_2.png) [@alejandrowunderlich](https://forum.bubble.io/u/alejandrowunderlich)\ **Post date:** [May 13, 2020, 11:12pm UTC](https://forum.bubble.io/t/get-historical-data-created-between-8am-10am/91621/1 "2020-05-13T23:12:46Z")
Hey guys, I’m trying to get all data entries since the start of April that happened between 8am and 10 am. What’s the best way to do this. Group by doesn’t seem to work for me here, and using “Created date \>= current date change to 8am, Created date \< current date change to 10am” of course only get me today’s data. What’s the best approach here? Thanks guys! ---
**Author:** ![alejandrowunderlich](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/alejandrowunderlich/32/97601_2.png) [@alejandrowunderlich](https://forum.bubble.io/u/alejandrowunderlich)\ **Post date:** [May 14, 2020, 4:55am UTC](https://forum.bubble.io/t/get-historical-data-created-between-8am-10am/91621/2 "2020-05-14T04:55:00Z")
Would be great if I could get some feedback. I’ve tried quite a few things and still can’t figure this one out… ---
**Author:** ![alejandrowunderlich](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/alejandrowunderlich/32/97601_2.png) [@alejandrowunderlich](https://forum.bubble.io/u/alejandrowunderlich)\ **Post date:** [May 14, 2020, 5:27pm UTC](https://forum.bubble.io/t/get-historical-data-created-between-8am-10am/91621/3 "2020-05-14T17:27:58Z")
Updated the post for clarity. What I’m attempting to do is simply filter, say, 30 day’s worth of data to only show data created between two sets of times. ---
**Author:** ![nfish](https://avatars.discourse-cdn.com/v4/letter/n/f14d63/32.png) [@nfish](https://forum.bubble.io/u/nfish)\ **Post date:** [May 14, 2020, 6:18pm UTC](https://forum.bubble.io/t/get-historical-data-created-between-8am-10am/91621/4 "2020-05-14T18:18:23Z")
you need to format the created date to 8am also to do the time of day filter, then do a separate filter for the date range. ---
**Author:** ![alejandrowunderlich](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/alejandrowunderlich/32/97601_2.png) [@alejandrowunderlich](https://forum.bubble.io/u/alejandrowunderlich)\ **Post date:** [May 14, 2020, 6:21pm UTC](https://forum.bubble.io/t/get-historical-data-created-between-8am-10am/91621/5 "2020-05-14T18:21:36Z")
**If you have a minute, could you elaborate a bit on this, please?** - What do you mean format created date to 8am? The DB is filled with entries at all times of the day. - “also do the time of day filter” Is this a 8am \< created date \> 10am type of filter? - “separate filter for date range” I’d love additional explanation on this, if you have a minute ---
**Author:** ![alejandrowunderlich](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/alejandrowunderlich/32/97601_2.png) [@alejandrowunderlich](https://forum.bubble.io/u/alejandrowunderlich)\ **Post date:** [May 19, 2020, 4:11pm UTC](https://forum.bubble.io/t/get-historical-data-created-between-8am-10am/91621/6 "2020-05-19T16:11:38Z")
I’m still struggling with this if anybody can provide some input, that would be very helpful! ---
**Author:** ![juancamilovasquezard](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/juancamilovasquezard/32/65341_2.png) [@juancamilovasquezard](https://forum.bubble.io/u/juancamilovasquezard)\ **Post date:** [May 19, 2020, 7:06pm UTC](https://forum.bubble.io/t/get-historical-data-created-between-8am-10am/91621/7 "2020-05-19T19:06:38Z")
Hi, I’m not sure If this is the best way, but may be it can help you. ![Captura de pantalla 2020-05-19 14.04.00](https://us1.discourse-cdn.com/bubble/original/3X/9/1/919c2462fdcb5d334a2f47dfd1db4dabe53a6b50.png) ![Captura de pantalla 2020-05-19 14.00.55](https://us1.discourse-cdn.com/bubble/original/3X/6/a/6a3077756f4fc151a7e406f759728c9ea8340007.png) ---
**Author:** ![alejandrowunderlich](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/alejandrowunderlich/32/97601_2.png) [@alejandrowunderlich](https://forum.bubble.io/u/alejandrowunderlich)\ **Post date:** [May 19, 2020, 7:11pm UTC](https://forum.bubble.io/t/get-historical-data-created-between-8am-10am/91621/8 "2020-05-19T19:11:55Z")
Thank you for this Juan! Would this work if your date picker had say, from the 1st of May - 19th of May? My issue is with extracting multi-day data. So 8am - 10am on May the 1st, 2nd, 3rd… and so on. Any ideas? ---
**Author:** ![juancamilovasquezard](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/juancamilovasquezard/32/65341_2.png) [@juancamilovasquezard](https://forum.bubble.io/u/juancamilovasquezard)\ **Post date:** [May 19, 2020, 7:26pm UTC](https://forum.bubble.io/t/get-historical-data-created-between-8am-10am/91621/9 "2020-05-19T19:26:35Z")
Yes It will works 😃 ![Screen-Recording-19-5-2020-14-23-58](https://us1.discourse-cdn.com/bubble/original/3X/d/a/da65585c2f363b3cd8b5fbd0781eab34d53016d5.gif)