Timezone Conversion

2013-06-24 Thread syed Ziyan
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. * **

Re: Timezone Conversion

2013-06-24 Thread Brent Goodman
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

Re: Timezone Conversion

2013-06-24 Thread Rick Westbrock
Of Brent Goodman Sent: Monday, June 24, 2013 0:53 AM To: arslist@ARSLIST.ORG Subject: Re: Timezone Conversion ** 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

Re: Timezone conversion

2011-10-11 Thread Christianne
Hi Axton, Thanks for your feedback... Luckily, I only have to worry about the DST, not the localized date/time format... I looked into the BMC 7.6.04 Configuration Doc and it talked about the Business Times commands that take Daylight Saving Time (DST) into consideration. See

Timezone conversion

2011-10-07 Thread Christianne
Hi Listers, Has anybody done timezone conversion before via workflow? I need to convert a date/time field to specific timezones. I've created an integer field that contains this epoch time value: 1317877200 (Thu, 6 Oct 2011 05:00:00 UTC) I'd like to solicit feedback on how to do

Re: Timezone conversion

2011-10-07 Thread Frank Caruso
The ARSLIST archives will have hundreded of posts on this topic. On Fri, Oct 7, 2011 at 1:49 PM, Christianne csoukn...@columnit.com wrote: Hi Listers, Has anybody done timezone conversion before via workflow? I need to convert a date/time field to specific timezones. I've created

Re: Timezone conversion

2011-10-07 Thread Axton
csoukn...@columnit.com wrote: Hi Listers, Has anybody done timezone conversion before via workflow? I need to convert a date/time field to specific timezones. I've created an integer field that contains this epoch time value: 1317877200 (Thu, 6 Oct 2011 05:00:00 UTC) I'd like to solicit