Skip to content
ProjectControls.com
Oracle Primavera - PM6

Date formats while exporting from P6

In the Open Standard
Jomon JoseMember for 15 years 2 months
Created
4
2
0

How can i control the date formats while exporting start dates from P6 to excel. When I am exporting in excel the format is appearing as m/d/yyyy but when my collegue exporting the format appearing is dd/mm/yyyy

 

How I can ensure everybody will have the same format while exporting the dates to excel from P6?

Jomon

Save Follow Follow forum Report
Reply New topic

4 replies

Oldest first
  1. 0
    Kumar S ·
    #1

    Dear Jose, you have to keep

    Dear Jose,

    you have to keep the same format in the edit preferances then you will get the same format i think

     cheers

    Report
  2. 0
    Jomon Jose ·
    #2

    Thanks for your comment. The

    Thanks for your comment. The user preference setting is same (Day,Month,Year) for both of us. But still the excel sheet is opening in different format. Also i request him to log on to P6 from my laptop then he also getting the format similar to me. Now i dont know any setting in my PC is the one controlling it.

    Report
  3. 0
    Jomon Jose ·
    #3

    Thanks for your comment. The

    Thanks for your comment. The user preference setting is same (Day,Month,Year) for both of us. But still the excel sheet is opening in different format. Also i request him to log on to P6 from my laptop then he also getting the format similar to me. Now i dont know any setting in my PC is the one controlling it.

    Report
  4. 0
    Ronald Winter ·
    #4

    Jomon,   The problem with

    Jomon,

     

    The problem with date formats in your spreadsheet has nothing to do with P6.  P6 exports a Julian date number.  Excel interprets that number and if the cell is formatted for dates, then will display the date in the default format.  Go to Format Cells, Number Tab, Category = Dates , and select the desired date type.  Good luck!

    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?