Friday, June 1, 2012

SharePoint 2007 auto-rolls date at 23:30

SharePoint 2007 has an annoying bug which automatically rounds "Today's Date" to tomorrow's date at 11:30PM or later.  This wasn't discovered until a Graveyard shift using SharePoint at that time.

A column using "Date & Time" field set to "Today's Date" but set to only allow "Date", will "jump" to the next day at 11:30PM, which can be a nightmare to fix.

I looked for a while on the internet to no avail.

The solution is to use a calculated value of "[Today]" rather than the built in "Today's Date".  Since "[Today]" has no concept of hours and minutes, it never rounds at 11:30PM.


No comments: