I publish one layer and use the layer in several applications, dashboards/webapps. I have an issue where I am trying to filter events within a web application using the Filter widgets where the filter needs to be within a date range. Using SQL Management Studio, I am able to query a certain date range and retrieve results, 47 for discussion. Using the dashboard, if I select the date, I retrieve the same number of results, 47. If I use the filter widget in a separate application, get back 49 results, with some of the results trickling into the next day. I've tried publishing with offsets to the time, but that just messes up the actual incident time, giving bad data.
It appears this issue was solved in ArcGIS Online BUG-000123859 "In Web AppBuilder for ArcGIS, the Group Filter widget filters off of UTC time and not local timezones." but I can't seem to find a workaround in WAB on Enterprise.
Any information regarding this issue is greatly appreciated.