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 am having trouble with out SharePoint calendar. I have some calculated columns set up to display start and end times for anything that is not an all day event (based off the guide here), but some items are displaying start and end times even when they are set to all day events.

After looking into this over the last couple of days, I created a calculated column simply set to:

=[Start Date]

and all items are showing the wrong time.

For example, I have one item which has a start time of 9/09/2013 12:00 AM, but the test calculated column is showing 9/09/2013 10:00 AM.

Any idea what could be causing this?

Edit: I just had a thought, I am in Australia (GMT +10), could this be having an effect on the way our times/dates are being stored?

share|improve this question
I have also tested this on another calendar on a different subsite and the same behaviour is displayed – Jason Crenshaw Sep 27 '13 at 5:35

Your Answer


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

Browse other questions tagged or ask your own question.