I am using a date picker to filter a table by using the date interval in the where clause of my query. like this:
... where
created_at >= {{daterangepicker1.startValue}} and created_at <= {{daterangepicker1.endValue}})
The syntax seems fine and working, problem is that if I choose for example from 5/1/21 - 5/31/21 it doesn't show any entry from 5/31. Last entry shown is from 5/30. My guess is that the problem is created_at has a time stamp, so <= 5/31 is considering 5/31 0:00:00
Any suggestions on how I can solve this?
Thanks!