We use a custom form in OST where the user selects the date/time of an event (in the past) to request data (ie CCTV footage). The form is using the built in date / time picker. Since the time change from EDT to EST, the following is occurring.
On the form during entry, the Date/Time picker shows EST which is the current time zone. The user picks October 17 @ 5:07PM from the picker as the date/time they are requesting data from. When they save the form (to create the ticket), the date time is written into the DB as October 17 @ 6:07PM EDT.
The system has recognized that October 17th was EDT (not EST) and made the 1 hour adjustment. Problem is the user wanted info from 5:07 not 6:07 which is what we see in the ticket and is causing some headaches for our agents when searching for data.
Any thoughts on how to ignore the time zone in this case without having to switch to a text box or UTC?
Thanks!
