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?
