SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've created a Calendar list. I've added a single calculated column ("Calculated Start Time") that simply references the "Start Time" column. It reports the correct date when the event is not an all day event. When I create an All Day Event, however, the calculated column reports 5 hours previous (i.e. 7pm the previous day).

It looks like when there is an All Day Event, the math for the calculated column is assuming the Start Date is in UTC or something (I am in Eastern Standard Time == 5 hour difference between UTC).

It looks like someone else has seen this behavior too:

Is this a known thing? Is it documented? Is it scheduled for fix?


share|improve this question
Is the time zone set properly for your Site? – Dave Wise Jan 10 '13 at 17:02
This is an issue regardless of the time zone settings. – Brian Jan 10 '13 at 17:52

This was fixed in the October 2012 CU pack. We had the same issue and the Oct CU fixed it.

share|improve this answer
I'll attempt to confirm this when I have some time to snapshot and apply the hotfix. – Brian Jan 10 '13 at 23:40
I applied the December 2012 CU, and this doesn't appear to be fixed (or maybe it has regressed again)? – Brian Jan 12 '13 at 21:23

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.