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
