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

Comments

Post a Comment

Popular posts from this blog

Dell Zino HD Remote Standard

Image
Took me hours and multiple calls to Dell Technical Support to find this information out. The Dell Zino HD uses the following IR standard for the Remote Sensor on the front: UPD6124A Here is the PDF specification:  http://www.datasheetcatalog.org/datasheet/nec/UPD6600A.pdf The support representative said most universal remotes use one of these two standards: RC5, RECS80 Unfortunately, this causes issues when trying to use a universal remote (example: XBOX 360 Universal Remote) with the Dell Zino HD.  A USB External IR sensor is needed to work with most universal remotes.  This is very confusing, as both devices list as a standard "Microsoft eHome Infrared Tranciever". What this means is that no remote -- other than the one that shipped with your device -- will work with your Dell Zino HD!  Scroll down to see my work-around. Since the Dell Zino HD only comes with 4 usb ports, the external sensor may have to be plugged in to the front of the device, which is partic
Read more

iPod Touch iPhone 3G Ubuntu 9.10 in 5 minutes

Image
"Lucid (Ubuntu 10.04) has 'out of the box', zero-configuration support in Rhythmbox for the iPod touch running firmware 3.12/3.13. It does not require jailbreaking, though I have personally discovered it will work with both a "stock" and a jailbroken iPod touch." - Raffisson Studio Changes (skip this) : Mar 28, 2010: Added link to French tutorial in step 1. Mar 16, 2010: Added Amarok 2.3 notes pe r Gary Feb 23, 2010: Removed "-dev" packages and made some small changes per farfouille64 feedback. Feb 19, 2010: Bifster found a similar tutorial. Worth trying if you have issues. Here's the link: easy way to sync your iphone Feb 19, 2010: Step 11 added DFB 's RythmBox plugin suggestion. Confirmation working with firmware 3.1.3! Thanks DFB! Feb 15, 2010: Step 11 added AJ's unicode work-around. Thanks AJ! Feb 11, 2010: Step 10 modified to automatically add user to group "fuse". Thanks for the
Read more

Pidgin - Microsoft Office Communicator

Image
Update: 11/15/10 - Added ICONV.DLL, LIBXML2.DLL work-around for Windows. Update: 05/01/10 - SIPE 1.10 is out. Tutorial updated. Update: 01/27/10 - SIPE 1.7.1 is out. Download it here . Update: 08/20/09 - SIPE 1.6.0 seems to be available, so I've updated this article with some 1.6.0 comments in red below. Steps: Downloading and installing the latest Pidgin for your platform. - Windows: For first time users, the installer will require GTK to be installed. - Windows: Recommended: Install automatic spell-check (Aspell) for your language, which needs to be selected during install. (Requires a connection to the internet). Download and install the latest SIPE ( SI mple P rotocol E xchange) for your platform. - Windows: The plugin will come bundled as a zip file with a MSI installer. Run the MSI installer. This will install the plugin to "Program Files\Pidgin" - Linux: If a precompiled version (usually ".DEB" or ".RPM" is not ava
Read more