I am thinking quickly on this and have not tested the solution but ... What if you used a SQL statement to get the CreateDate value directly from the database, which is in GMT. Then, using the DateAdd function in Remedy, add that value to 01/01/1970 and store it in a date field. Take that value and set it to a character field and use in your web service.
HTH Frank On Tue, Aug 18, 2009 at 10:23 PM, Nall, Roger<[email protected]> wrote: > ** > Hello All, > > I have a request to send the Create Date of a ticket to an external > application via a Web Service. This must be passed as a string and needs to > be in GMT. My server is in NJ thus the server time is Eastern. The issue is > how to handle Daylight Savings time. I could do this by checking the > date/time value to see if it falls between March 8 and November 1 but that > only takes care of this year. I wanted to check to see if anyone may be > doing something like this now that they can share. > > Thanks, > > Roger Nall > Manager, SA Remedy > Desk Phone: 972-464-3712 > Mobile: 973-652-6723 > > > > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

