Date or datetime fields are stored as a number in the database. For Datetime fields this is the number of seconds since 1st January 1970, _UTC_. I guess in your situation a user has submitted lots of data while using a wrong timezone, which means a wrong offset to UTC. If you correct the user's timezone, the data previously entered by the end user can be a couple of hours off. Please note that it /does not have to be/; depending on your setup and application, some fields are populated on the server side; they do not mind the timezone setting on the client.
What you can do is export the form with the data you need to adjust, for instance to .arx format, add or substract the number of seconds of your offset (for instance if you want to substract 2 hours, substract 2 * 60 * 60 = 7200 seconds from the value in the ARX file. You can use MS Excel or so to do this. After this, you can import the data back into Remedy. As I said, please take care when adjusting your data as it might be that not all fields are affected. Kind regards, -- Michiel Beijen Software Consultant +31 6 - 457 42 418 Bee Free IT + http://beefreeit.nl On Wed, Oct 15, 2008 at 7:59 PM, sreenivasreddy kotha <[EMAIL PROTECTED]> wrote: > ** > Hi Listers, > > I posted this query long back. I didn't received any solution. Do we have > any technique here? > > Thanks > Sree > > On Sat, Sep 27, 2008 at 12:26 AM, Sreenivas Reddy <[EMAIL PROTECTED]> > wrote: >> >> Hi All, >> >> Environment Details >> >> SunOS 5.10 (Solaris) >> Oracle 10g >> ARS 7.0.0.1 Patch3 >> >> When User update Time Zone from Tools->Options->Locale->Time Zone >> through Remedy User, It is being updated in ARSystem User Preference >> Form. All the Date/Time fields are displaying based on Time Zone >> settings, but Time fields are not updating. I know remedy will not >> change the Time fields based on Time Zone. How to update Time fields >> through remedy Workflow. >> >> Thanks, >> Sree >> >> >> Sreenivas Reddy wrote: >> > Hi All, >> > >> > How to update Time field based on Timezone. I knew that Remedy won't >> > support this(like Date/Time field), but can we do it through workflow. >> > Please let me know the solution. >> > >> > Thanks, >> > Sree >> > >> > >> > _______________________________________________________________________________ >> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
