Dan Lewis' Development and Technology Blog

How to fix “Input string was not in a correct format” when using calculated date columns in a SharePoint / WSS list calendar view

Posted by: djjlewis on: 10/11/2010

When I recently tried to create a new SharePoint / WSS calendar view on a list that uses calculated columns for the both the start and end dates, I was greeted with the following error message:”Input string was not in a correct format”

After quite a bit of trawling the web (hence this blog post), it seemed to be a known issue in certain version of SharePoint / WSS. This particular server was already at SP2 (12.0.0.6421) so I decided to go ahead and install the latest CU – currently August 2010 (12.0.0.6545).

After installing the CU, rebooting and running through the farm configuration wizard, I recreated the calendar view and this time everything worked perfectly.

Here’s a handy reference to the available SharePoint hotfixes and version numbers.

Advertisement

1 Response to "How to fix “Input string was not in a correct format” when using calculated date columns in a SharePoint / WSS list calendar view"

What is a CU?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s


  • Felipe: Excellent!! Great advice! it worked for me
  • luckybhumkar: Your help solved my problem thanks buddy for this nice hellp!
  • Craig: Thanks, this saved some troubleshooting time. Got to love those descriptive error messages.

Categories

Follow

Get every new post delivered to your Inbox.