Time Variable Timezone

[MichaelH5716707]

I have a need to have a time or date/time variable to allow either timezone selection or have a static timezone. So essentially if I am placing a time for a facility that is located in Eastern timezone but I am viewing in Pacific Timezone I don't want the time to be converted I need it to stay as the time entered. Can anyone suggest options?

[jcmings]

In that case, you should be able to go the custom field route. You may need to convert the UTC time into the location's local time on the record. To do this, I would recommend adding a timezone field (copy it over from sys_user) to the Location table (assuming you store your locations on there). Then, via script, you'll be able to convert the UTC time to the local time and set the display value on the delivery record using the script above.

[MichaelH5716707 · Accepted solution]

I opted to do something like this I wasn't aware of the UTC field type so this was the best solution because of the need for a time that doesn't change. Obviously this is not accurate because the local time is being treated as UTC time so conversions aren't accurate or possible. This was a quick fix since this was the groups oversight when this project was being built and it just needed a quick solution. If they want to be able to do proper reporting or tracking down the line (which I disclosed now) they will need to request a different process. And now they learned the lesson of not being fully aware of what the project requires going forward.

[jcmings]

I think I'm a little lost by your response. You can convert the times. The times are converted to UTC by the system for their storage. And they display based on your local time. That is an example of conversion being possible.