So database is in the cloud, in UTC timestamp. Gateway is also in the cloud, with UTC timezone. Whoever created the project, also configured to be UTC timezone. The End User in on EST timezone. I have records in database that I want to filter by datetime. The date picker is headache. Biggest he…

Start here, follow links: [image] Timezone related issue Ignition Ignition's DateTime tags, and datetime values/timestamps throughout Ignition, use the java.util.Date data type. This type is fundamentally UTC. Any datetime parsing or printing automatically a…

For record, education. Below is what I did. Please feel free to comment. Again, gateway and project is on UTC timezone. But date picker is in Browser timezone. When I initialized date picker using system.date.now() (which is in UTC), it doesn't work. I need to spoof it: def convert_utc_to_brow…

Interrestingly, my convert to utc midnight does not work on the daylight saving day March 8. I use this function to get Est Midnight (in UTC): def convert_utc_to_est_midnight_inUtc(utc_date): from java.text import SimpleDateFormat from java.util import TimeZone, Calendar utc_string = system…

Timezone, date picker problem

Ignition

pturmel March 7, 2026, 8:06pm 2

Start here, follow links: