How to filter results to show only the last 30 days?3 followers
- end_time (date time)
- entity (string)
- sub_entity (string)
- successful (boolean)
- instance (string)
I want to filter so only rows where end_time is within the last 30 days. So ... like ... NOW minus 30 days. I want this to show data for the last 30 days regardless of if it's ran today or a week from now; it's always 'the last 30 days' of information.
I tried a few things and they didn't work. Did a lot of searching; not much out there. Please help!
Here's what I've tried:
DAY(NOW(#end_time)-30d) I likely have no idea what I'm doing here and that's why it failed :)
#end_time >= 30 didn't work .. again... likely because I don't know what the heck I'm doing here.