I'm using some named queries in an expression binding to pull in data. These queries are using the formatted parameter of some date pickers for a date range.
I was expecting to have Ignition convert the datetimes to the gateway's timezone, similar to how a system.db.runPrepQuery reacts, but it does not. Probably because the Jython scripting is being used.
Should I just rewrite my bindings with a transformation script and run the named query that way?
Or, is there a way to convert the user input datetime into UTC in the background?