I have a calendar item as part of my MOSS 2007 site and would like to show the events coming up in the next 30 days on my home page.ÃÂ After some research I understand that I cannot filter on the Start Time field when I try to create a view, so I've created a new field called Event Begin that is a calculated field set to =[Start Time].ÃÂ I can then create my view for the upcoming events by filtering on the calculated Event Begin column.
This works well, except for events that are marked as All Day.ÃÂ In this case, the value of the Start Time shows midnight as the time (i.e. 1/11/2008 12:00 AM) which is fine, but the value of the Event Begin column shows the time 5 hours earlier (i.e. 1/10/2008 7:00 PM).ÃÂ I am not subtracting anything when calculating the Event Begin value, so my initial thought is that I have a conflict between Time Zone settings somewhere.
I am Eastern Standard Time here in the US which is GMT-5:00, which would explain the 5 hour difference.ÃÂ Unfortunately, I cannot figure out where the incorrect Time Zone setting might be.ÃÂ Within my site the time zone is correct (under Site Settings >
View Complete Post