Skip to content
ProjectControls.com
Oracle Primavera - PM6

Export dates form P6 to Excel in European format

In the Open Standard
Alberto HomedesMember for 14 years 11 months
Created
4
4
0

Hi,

I need to export the start and the finish dates from P6 to excel, but I need that when I have this in excel, I can use this information how dates no how text. And I want to know If somebody export to excel, the dates with date format no like text.

Thank you

Save Follow Follow forum Report
Reply New topic

4 replies

Oldest first
  1. 0
    Ronald Winter ·
    #1

    Alberto, Are you asking how

    Alberto,

    Are you asking how to format your dates as just a series of numbers?  You do this formatting in Excel.  Highlight the fields (or column) and then right-click, “format cells” and pick the desired way of displaying your dates.  Good luck!

    Report
  2. 0
    Thomas Nicholson ·
    #2

    I suspect he's asking the

    I suspect he's asking the question I asked last week.

    When exporting from P6 the date appears in Excel as

    '12-12-11' and using replace will not work as it claims it can't find the ' part you want to replace thus rendering it useless for analysis in Excel.

     

    Thom 

    Report
  3. 0
    Thomas Nicholson ·
    #3

    I suspect he's asking the

    I suspect he's asking the question I asked last week.

    When exporting from P6 the date appears in Excel as

    '12-12-11' and using replace will not work as it claims it can't find the ' part you want to replace thus rendering it useless for analysis in Excel.

     

    Thom  

    Report
  4. 0
    Mimoune Djouallah ·
    #4

    in excel, select the columns,

    in excel, select the columns, then data, text to columns, delimited, then date, select DMY, finish

    excel will change the date format to your computer date format, then you can use the for your reports

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?