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

Posted on 2002-05-02
Medium Priority
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...
Question by:SuperLeon
LVL 18

Expert Comment

ID: 6986769


Expert Comment

ID: 6987951
also listening...

Don't know if the following article would help or not:
Calendaring: Understanding the Client Side

Accepted Solution

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    
     '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    
     if now() <= DSTEndDate and now() >= DSTStartDate then
          GMTDateDiff = 4
          GMTDateDiff = 5
     end if
end function
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

LVL 18

Expert Comment

ID: 7006532
you complete me.
LVL 15

Expert Comment

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


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

Expert Comment

ID: 8796620

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



Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
In the video, one can understand the process of resizing images in single or bulk. Kernel Bulk Image Resizer is an easy to use tool for resizing large number of images. One can add and resize multiple images with this tool in single go. The video sh…
Did you know PowerShell can save you time with SaaS platforms? Simply leverage RESTfulAPIs to build your own PowerShell modules. These will kill repetitive tickets and tabs, using the command Invoke-RestMethod. Tune into this webinar to learn how…

627 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