I have a dashboard where I use a time input. If I go to Between Date Times and say I select dates of 11/12/2019 08:00.00.000 and 11/12/2019 10:00.00.000, what happens is that the input displays data from 07:00.00.000 to 09:00.00.000, which is 1 hour off. Is there a way to fix it so that the time input only pulls data for exactly the time selected? Thanks. If more info is needed please let me know.
Thank you for your reply but the problem we run into is that the search works sometimes and not other times. We do not think it is a time zone issue. If its a timezone issue it would not work at anytime.
What do you mean "sometimes and not other times"?
Who is running the search? What are their personal preferences set to for timezone? What timezone is the server running on?
99% chance this is a timezone-related problem.
Say I enter 11/12/2019 8:00.000 to 10:00.000, all the data between these 2 times is displayed which is fine, but other times instead of displaying data between 8 and 10 it will display it from 7 to 9. The server is running on ET.
Best practice is to always run every server on UTC (since that will always match Unix epoch time)
What you're describing is a timezone issue
Either the data coming-in is off-by-1-hour
Or the user's timezone is off-by-1-hour
Or the server's time is off-by-1-hour
Or some random combination of the above
I've seen this countless times over the last dozen+ years - with maybe one exception in all that time, it was a time zone issue