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"

Reply via email to