Once you save a timestamp in a text field, it will never change because its now considered just text.
The only way to get that value to change, to reflect the current time zone, is by storing it in a Date/Time field on the form. Then the Remedy system knows how to adjust. We have the same issues with email notifications. Once the date/time is put into the body of the email, it won't change to reflect the users zone. The solution in this case was to drop PST or EST after any time entries. For one of our clients, this is the first line of text in every email that goes out: "Note: All Dates and Times (if applicable) are in Pacific Time" Sent from my iPhone On 2013-06-23, at 11:23 PM, syed Ziyan <[email protected]> wrote: > ** > Hi All, > > We have an external system where Remedy receives Updateds and create record > in WorkLog of a form in Text format. In this text format a datetime > information is stored as UTC Zero offset "2013-06-24T10:10:10" format. > Now whenever User opens it, view the value instead of local time. > > Can you have any idea how to convert it to epoch timestamp or can it be > changed to local timezone of user. > > Appreciate your help. > > Thanks > Ziayn > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
