I am new to SharePoint (2010), and my company has recently migrated a Document Library from a different Content Management System. The Doc. Lib has been set up with Content Types and custom Word (2010) Templates to provide a specific structure to the documents.
There is a requirement that the Metadata Columns be embedded into the content of the Word Documents, which we have done. However, we are an international company, so we are spread through several time zones.
Two of the fields in the documents are date-only datetime fields, but these fields must contain non-time zone aware dates. In other words, regardless of which timezone the document was created in or added to SharePoint, all users world-wide must see the
When we create the documents by using the "New Document" menu in SharePoint, and fill in the Document Information Panel in Word, the dates work as required. However, if we use the "Upload Document" option, and then fill in the properties in the Default Edit
List window, then the dates are time-zone aware, and users in an earlier (further west) time zone see the date as one day earlier.
After some investigation, it seems that Word stores the dates in the format yyyy-mm-dd hh:mm:ssz, with no offset information, and SharePoint then doesn't apply an offset when displaying/storing the data. However, when
View Complete Post