Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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?

TIA

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.