It appears that the webappbuilder query widget has a showstopping bug when querying dates. I've formatted the date several ways now. Any which way I do it, the query widget returns results for the wrong date. When the query expression is setup, it gives it a default date of today. You can't clear it. The results from running the query are always from the wrong day. One option I explored was picking the "unique" date from a dropdown but that isn't a viable option. For one it's cumbersome and secondly the dropdown isn't sorted correctly when you use the most common date formats like dd/mm/yyyy. Has anyone ever found a way to trick this widget into working properly with dates?
It returns a date for the previous day instead of the day specified. I don’t know that its always the previous day. It may be whatever the day is when the expression is originally setup. I should also mention that our date fields will sometimes have hours minutes and seconds populated. Specifically, we have date/time for a scheduled inspection. Whatever date is selected from the calendar in the widget the results are returned incorrectly. I’ve tried to format it as a string instead of a date but that won’t work either.