SharePoint and Office Quickpart date formatting


Recently we had an issue with date formatting within Office 2007/2010. When you drop a QuickPart field which references a date field in SharePoint the date formatting will not be equal to the regional settings of the SharePoint site where the document resist. The solution to this problem is rather simple, when you have spent some time digging into Office 2010.

· If the situation that the Developer tab in Word is not enabled, enable it.
Word 2007: Word > Options > Popular
Word 2010: File > Options > Customize Ribbon in Word 2010

· In the document, insert the document property as usual.

· Click the document property, then click on its name (see figure).
Click Developer tab > Controls group > Properties

· Now you are able to modify the date formatting by selecting one of the predefined formats from the list or by defining a custom format.

· Click OK

There you go! A custom format has been set. Unfortunately this is not a solution in a multi-language environment. Every template has to be preconfigured.

Advertisements

About Cloud Architect Joran Markx
I have been working on Microsoft Technology since 2003. In addition to (lead) developer and software architect, I am certified Microsoft Specialist and active in design and implementation of Hybrid Cloud platforms. In 2011 I have achieved a Master of Science in IT Management. This made me capable to solve complex issues from the business in an efficient and structured way. As Cloud Architect I am working on various challenging projects with a variety of clients. Within my organisation I fullfill a leading role when it comes to internal development and sharing of knowledge. My goal is to provide reliable and predictable services to our clients with a strong focus on the results achieved for the organisations I am working for.

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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: