Search on single date
Content
Hi all,
I have a docked filter where a user can search a date/time type field for incidents submitted on a certain date, however whenever a date is selected it takes the current timestamp and uses that as part of the search criteria, which unless an incident was submitted on that exact day and time, will return nothing. I've noticed that if after selecting the date, I manually change the time stamp to 00:00 AM it will return all of the incidents submitted on that date. I've tried using date_trunc() to truncate the timestamp to no avail. Any advice would be greatly
Tagged:
0