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: http://weblogs.asp.net/zekemouseover/archive/2010/05/11/start-time-amp-calculated-column-wonkiness-in-a-sharepoint-event-calendar.aspx

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


  • Is the time zone set properly for your Site?
    – Dave Wise
    Commented Jan 10, 2013 at 17:02
  • This is an issue regardless of the time zone settings.
    – Brian
    Commented Jan 10, 2013 at 17:52

2 Answers 2


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

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

Try using this formula in the Start Date calculation:

=TEXT(IF([End Time]=[Start Time],[Start Time],IF(MOD(ROUNDUP(([End Time]-[Start Time])*24,0),24)=0,[Start Time]+1,[Start Time])),"dd mmm yyyy")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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