Glad I could help! :) Kaustav
On 11/28/06 10:47 AM, "Willochell, Mike" <[EMAIL PROTECTED]> wrote: > Hello Kaustav, > > Hmmm...I was thinking along those lines, but because of daylight savings > time, we alternate between -5 GMT and -4 GMT, and this doesn't start and > end on the same day every year, that's what's tricky. > > You did however give me an idea. If I took the value from the database, > say (04/15/2004 06:47:23), and used the <@TOGMT> tag, I can then take > the difference between the original value (04/15/2004 06:47:23) and the > value returned from the <@TOGMT> tag (04/15/2004 10:47:23) to determine > on that particular date and time, our local time was -4 GMT. I can now > subtract four hours from the original value and get the local equivalent > of (04/15/2004 02:47:23). > > Thanks for getting the wheels turning! > > Mike > > > -----Original Message----- > From: Kaustav Acharya [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 28, 2006 1:18 PM > To: [email protected] > Subject: Re: Witango-Talk: GMT to Local Time > > Hi Mike, > > I think the only way to do this is to get the time from your application > and > hardcode a mathematical equation that subtracts the number of hours. To > my > knowledge I don't think there is a tag that takes it from GMT and > converts > it to local. If your server is running the current time perhaps you can > just > get the timestamp from that? > > Thanks! > > Kaustav > > > On 11/28/06 10:13 AM, "Willochell, Mike" <[EMAIL PROTECTED]> > wrote: > >> Hello, >> >> I'm either having a "Duh" moment, or it isn't as simple as I'm >> expecting, but is there a meta tag or function in Tango that takes a >> date-time stamp in GMT format and gives you the local equivalent, > taking >> into consideration daylight savings time? I see the <@TOGMT> tag, but >> this seems to do the inverse of what I need. >> >> I have a reporting app I wrote in Tango that pulls document data from > a >> SharePoint database, and for whatever reason, SharePoint stores it in >> GMT time, but displays it in local time. I need to display it in local >> time as well on my reports so that the users aren't confused. >> >> Thanks in advance. >> >> Mike >> >> >> > ________________________________________________________________________ >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
