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!
Would be great if I could get some feedback. I’ve tried quite a few things and still can’t figure this one out…
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.
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.
If you have a minute, could you elaborate a bit on this, please?
I’m still struggling with this if anybody can provide some input, that would be very helpful!
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?
Yes It will works 
