Solved

Daylight savings time adjustment in Outlook Meeting (.vcs) file?

Posted on 2002-05-02
7
727 Views
Last Modified: 2008-01-09
I'm dynamically creating a Microsoft Outlook Meeting file (.vcs file) through an ASP page that gets appointment info out of a database. I then link to that file on the web page. This process works fine.
Here's the problem:

Appointment times are all in US Eastern Standard Time. When I create the .vcs file, I generate the time for the appointment to be in GMT (so I add 5 hours to the appointment time).

10:00 am EST = 3:00 pm GMT

so in a vcs file...

5/2/2002 10:00am EST = 20020502T150000Z

This supposedly should automatically make the adjustment in a client's Outlook when they open up the vcs file. However, ever since daylight savings time has passed, some of my users around the world have been getting appointment times showing up as an hour off.

I ran a couple of tests on my machine and I noticed that when I have the Windows setting: 'Automatically adjust for daylight savings' turned on, the times are 1 hour out of whack. When I turn it off, the times are ok.

Anyone have any ideas on how to get around this? Any way of determining if a clients system is set to automatically adjust daylight savings?

Thanks in advance...
0
Comment
Question by:SuperLeon
7 Comments
 
LVL 18

Expert Comment

by:bruno
ID: 6986769
*listening*

0
 
LVL 6

Expert Comment

by:gete
ID: 6987951
also listening...

Don't know if the following article would help or not:
Calendaring: Understanding the Client Side
http://www.exchangeadmin.com/Articles/Index.cfm?ArticleID=7697
0
 
LVL 1

Accepted Solution

by:
SuperLeon earned 0 total points
ID: 7006440
I couldn't find a really good way around this so I succumbed to the quick fix 'hey...it works doesnt it?' method. According to the time of year, I adjust the number of hours I add to the current date to account for daylight savings time (since most computers are set to automatically adjust for it). I created a function that returns the hour difference between EST and GMT. It returns 4 or 5 depending on the time of year. Seems to work.


function GMTDateDiff()
     'this function calculates the GMT hour time difference
     'taking into accoun Daylight Saving Time (based on server current date)
     
     DSTyear = year(now)
     
     'DST is between first Sunday of April and Last Sunday of October
     
     'find first Sunday of April in current year
     for x = 1 to 7
          DSTchkDate = cdate("4/" & x & "/" & DSTyear)
          if weekday(DSTchkDate) = 1 then
               DSTStartDate = DSTchkDate
               exit for
          end if    
     next
     
     'find last Sunday in October in current year
     for x = 31 to 25 step -1
          DSTchkDate = cdate("10/" & x & "/" & DSTyear)
          if weekday(DSTchkDate) = 1 then
               DSTEndDate = DSTchkDate
               exit for
          end if    
     next
     
     if now() <= DSTEndDate and now() >= DSTStartDate then
          GMTDateDiff = 4
     else
          GMTDateDiff = 5
     end if
end function
0
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 
LVL 18

Expert Comment

by:bruno
ID: 7006532
you complete me.
0
 
LVL 15

Expert Comment

by:gladxml
ID: 8795666
No comment has been added lately and it seems that this question have been abandoned. So it's time to clean up this TA.

I will leave a recommendation in the Cleanup topic area that this question or invite a Moderator to close this question if there's no reply from you after seven days.

In the absence of responses, I will recommend the following:

Question PAQ and point refunded

** PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER **


Just trying to help for the cleanup...
gladxml
0
 
LVL 18

Expert Comment

by:bruno
ID: 8796620
mod,

please accept superleon's comment above with the code as the answer if possible.


thanks,

bruno
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
two-way Authentication ASP 3 89
JQuery Date Time picker not showing 29 129
Summernote and form validation 10 133
Auto Submit on dropdown box 14 64
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question