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. -Tres