SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We are using Sharepoint WSS 3.0 and MS Office 2007. When ever we create or update a document's 'effective date' in the document's properties (under Prepare--> properties) and save to the server, it adds an extra day to the 'effective date' when shown in the document library.

Example: Document properties: Effective date- 6/3/11 Sharepoint document library column: Effective Date- 6/4/11

Please Help!

share|improve this question

First thought is to check the time/date and time zone on the servers in your SharePoint farm, then check the time zones for the web applications, then check the time zones on the client machine. Sounds like there is something that is not coordinated in those locations.

share|improve this answer
It isn't pulling a date off of anything on the server or machine. It should just be pulling the date field from the document, which can have a completely different date than the 'today' date. – user3140 Apr 22 '11 at 4:08
Yes, but my thought is that the properties of that date include the timezone where the date was set, and would adjust it to match what the date would be on the servers. – Lori Apr 22 '11 at 15:28

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.