You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Search on single date

Accepted answer
12
Views
7
Comments
edited Sep 14, 2016 1:14PM in Reporting & Analytics for B2C Service 7 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!