My Oracle Support Banner

When Exporting Data From P6 Using Spreadsheet (XLSX) Option With Time Set to “Do Not Show”, Time is Still Shown Within Excel. (Doc ID 2524811.1)

Last updated on AUGUST 15, 2019

Applies to:

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

Symptoms

ACTUAL BEHAVIOR:

When Exporting data from P6 using Spreadsheet (XLSX) option with Time set to “Do Not Show”, Time is still shown within Excel.

STEPS:

  1. From P6 Professional Activity window, the start date is set as date without time (eg: 13-Jul-18 A). User Preferences is set to not show time.
  2. From the General tab, it also is shown as 13-Jul-18 for the started date.
  3. Click File Export. Select Spreadsheet - (XLSX).
  4. Select Export Type as Activities.
  5. Select Finish.
  6. Date is shown within Excel with Time (13-Jul-18 08:07).

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.