Import XLS Flips Day/Month Of Date Values Entered

(Doc ID 2289616.1)

Last updated on AUGUST 01, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version and later
Primavera P6 Professional Project Management - Version and later
Information in this document applies to any platform.


Constraint dates imported via XLS are flipping the Month and Day opposite of the Date Format selected in the User Preferences.

User Preferences Date Format is used to determine the Month/Day or Day/Month of the importing date values.

The issue can be reproduced at will with the following steps:

  1. Change the system date and time setting to use Day/Month/Year.
    1. Click on the time in the lower right of the computer
    2. Click 'change date and time settings..."
    3. Click 'change date and time'
    4. Click 'change calendar settings'
    5. Modify the "short date" value to dd/mmm/yy
    6. Click Apply
  2. Login to P6 Professional.
  3. Set User Preferences 'Date Format' to "Month, day, year".
  4. Export a project to XLS (with a constraint type and date already applied).
  5. Modify the constraint date = '03/04/2017 12:00 AM.
  6. Save the file.
  7. Import into P6, updating the existing project.
  8. Note that the constraint date will come in as April 3rd, not March 4th.

The issue has the following business impact:
Due to this issue, users cannot import the dates correctly.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms