I've recently noticed that my email Alerts display an incorrect Start and End Time if the alert is for the creation of a Calendar item set as an All Day Event.
If you view the item in the site calendar - the time displays correctly. It's only the text in the email Alert that it is incorrect.
It appears the time is displayed in the email using GMT timezone even though my web app regional settings as well as site-level/personal-level regional settings are all set properly (Central time).
What's even stranger still is that Alerts for Edit/Delete actions on the SAME ENTRY actually show the CORRECT TIME in the email.
It's only the first Alert email for newly created All Day Event items that have incorrect times.
If you create an entry for a non-All Day Event (i.e. you manually specify a particular time range) - the times are correct.
I have open posts on MSDN forums and newsgroups, but so far no replies...
If you view the item in the site calendar - the time displays correctly. It's only the text in the email Alert that it is incorrect.
It appears the time is displayed in the email using GMT timezone even though my web app regional settings as well as site-level/personal-level regional settings are all set properly (Central time).
What's even stranger still is that Alerts for Edit/Delete actions on the SAME ENTRY actually show the CORRECT TIME in the email.
It's only the first Alert email for newly created All Day Event items that have incorrect times.
If you create an entry for a non-All Day Event (i.e. you manually specify a particular time range) - the times are correct.
I have open posts on MSDN forums and newsgroups, but so far no replies...
I would question my recent troubles with KB 934525, but the problem is also visible on a test server that doesnt have 934525 applied. I honestly cannot say for 100% certain the issue hasn't been there since install - but I really think someone would have noticed by now. I've had this system running for several months. If I get some time I'm going to wipe a test server and reinstall clean and see if the problem still exists. I'll update later with my findings.
Any other info/ideas would be appreciated-
Any news about this issue? I have exactly the same problem.
ReplyDeleteI'm located in GMT+2 but when I create all-day calendar item I receive alert that this event begins at 2:00AM and ends at 1:59. It shifts the time for these 2 hours.
SP1 applied.
Sorry, unfortunately I don't have any additional updates/info on this problem. You can view an MSDN forum post I have going on the subject, but so far no answer: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2282699&SiteID=1
ReplyDeleteThis is a problem with SharePoint and modified date/time fields. If you use a normal "number" filed and then display it as a date in a webpart view it works fine. Try to dispaly it in a Data view (or what you are doing) it shows GMT.
ReplyDeleteDont know why, but here's my hack... the block of code calculates weather the date is in DST or not.
Set this up in a calculated field in your list:
Field Name: Display_Date
= DTField + (([TZD]+ IF(AND((IF(WEEKDAY(DATE(YEAR(DTField ),3,1))<>1,8-WEEKDAY(DATE(YEAR(DTField ),3,1))+7,0)+DATE(YEAR(DTField ),3,1))<=DTField ,DTField <=(IF(WEEKDAY(DATE(YEAR(DTField ),11,1))<>1,8-WEEKDAY(DATE(YEAR(Date),11,1)),0)+DATE(YEAR(DTField ),11,1))-1),-1,0))*(1/24)))
Display_Date = The display field you will use to contain the modified time.
DTField = the date/time field you are working with.
TZD (Time Zone Displacement) = +/-GMT without DST (Central = 6)