cer2225
Posts: 1
|
| Posted: 11/14/2007, 6:40 PM |
|
I have created a calendar that gets its data from a SQL server back end. The problem is the data is in UTC format and I need it in EST format. The date and time is in one field called {Actual_Start} Is there an asp script that I can use that will convert that before anything is done with it? I found a script that adjusts the EventTime by -5 hours but that doesn't help when it comes to placing the information on the calendar. The time shows up correctly but any event that is 7pm EST or later the date shows up on the next calendar date since the value is UTC. I am by no means a programmer so this has been a struggle.
Any help would be appreciated.
Thanks
|
 |
 |
|