Roger: I dealt with this problem years ago and found that the only way to deal with dates from way back to present is to hard-code the times that DST applies each year and hard-code your timezone.
Since DST (at least in US) is subject to the whims of legislators, there is clearly no systematic formula that will compute the dates DST is on and barring connecting GPS to your computer and reading its data into the function, there is no surefire way to know where the user is located when they may be moving from place to place (i.e., with portable computer or PDA, etc.) Fluxman -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Frank Caruso Sent: 08/19/2009 12:31 AM To: [email protected] Subject: Re: Convert Remedy Time to GMT 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

