Microsoft Knowledge Base Email Alertz

In Microsoft Project, Custom Enterprise Date field displays date in 1984 instead of NA

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

Article ID: 2255457 - Last Review: July 8, 2010 - Revision: 1.0

In Microsoft Project, Custom Enterprise Date field displays date in 1984 instead of "NA"

Symptoms

In Microsoft Project Professional, when you type "NA" in a customer Enterprise Date field, the date may revert to a date in 1984 after you close and reopen the project from the Project Server.

Resolution

If you wish to reset the value in the field to "NA", use one of the following methods:

  • Click the cell containing the date, and then press the Delete key to remove the value.
  • Click the cell containing the date, and then press the Backspace key to remove the value.
  • Click the cell containing the date, and then press the Space key to remove the value.

More Information

This issue has been observed in Microsoft Office Project Professional 2007.  It also occurs in Microsoft Project Professional 2010 when the Task Mode is set to Auto Schedule.

To provide further clarification of this issue, following are the steps to reproduce the behavior:

  1.  In Project Server, click Server Settings, and then click Enterprise Custom Fields and Lookup Tables.
  2. Under Enterprise Custom Fields, click New Field.
  3. On the New Custom Field page, enter the following information:
    • Name: Date Field Test 1
    • Entity: Task
    • Type: Date
  4. Click Save and exit Project Web Access or Project Web App.
  5. Start Microsoft Project Professional and log on to the Project Server.
  6. Create a new blank project.  If you are using Project Professional 2010, in the status bar click New Tasks, and then click Auto Scheduled.
  7. In Task Name, type T1 to create a new task.
  8. Right-click the Duration column header and then click Insert Column.  Insert the column Date Field Test 1 that you created in Step 3 above.
  9. In Date Field Test 1 for task 1, click the drop down and use the date-picker to set the field to today's date.
  10. Save and publish the project.
  11. In Date Field Test 1 for task 1, click the cell and type NA.
  12. Save, publish and close the project.  Click Yes when you are prompted to check-in the project.
  13. Using the appropriate method for your version of Project Professional, clear the cache using the Clean Up Cache feature.
  14. In the File menu, click Open, and then click Retrieve the list of all projects from Project Server.
  15. Click the project you created in Step 10, and then click Open.

When you open the project, you would expect to see the value in Date Field Test 1 is "NA".  Instead, the value is a date in 1984. 

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use (http://go.microsoft.com/fwlink/?LinkId=151500) for other considerations.

APPLIES TO
  • Microsoft Office Project Professional 2007, when used with:
    • Microsoft Office Project Server 2007
  • Microsoft Project Professional 2010, when used with:
    • Microsoft Project Server 2010
Keywords: 
KB2255457
       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate