We are running a process based on given exact Date Time which is stored in UTC entered by the user in the UI with schedulers. Lets take example the scheduler planned to run at 11/10/2024 12:00 AM, and its stored in DB as 11/10/2024 -4:00 UTC. When time zone change from EDT to EST its coming as 11/09/2024 11:00 PM which kicks the process 1 hour before which is not expected. I'm wondering so all the dates entered or captured in DB during EDT will be shown in Appian as Actual time - 1 hour. Isn't this unusual?
Discussion posts and replies are publicly visible
All the time which get stored in DB are in GMT. You would need to consider that while bringing the values back from DB. Personally I also have struggles with how time keep changing due to timezones and DB
Maybe my blog post helps a bit: https://appian.rocks/2023/02/13/working-with-time-in-appian/