Requirement: Display the value in DateTime picker control exactly how it was entered regardless of time zone (in "MM/dd/yyyy hh:mm [AM|PM]" format).
Problem Case:
We have employees in multiple time zones. Our form has a DateTime Picker control where employees enter the date and time for a change request for IT. All employees have been instructed to enter all times in as EST, unfortunately this has caused some scheduling problems. For example, Cliff in Illinois (CST) requests a change for 12:00 AM EST; however, when Bob from IT opens the form in Florida, the value displayed in the DateTime Picker control is 1:00 AM EST.
I've been reading other posts that describes how the control renders the time (UTC +/- #hours), but haven't seen a NON-CODING solution to rendering the exact value entered into the control. Do formulas have a role in solving this?
Thank you in advance for your help.