Skip to content
ProjectControls.com
Planning, Scheduling & Programming Discussion

Excel Dates to P6

In the Open Standard
Ferdinand AnchetaMember for 18 years 11 months
Created
4
3
0

Is anybody here could inform me what format of start & finish dates in excel that could be imported straight in P6 and gives me the correct dates to P6? Is this possible? If so, this will save us time to create a project in P6 wherein we don't need to input anything in P6 but by importing all data from excel like activity ID, Activity Name, Start and Finish dates. Thus, do i need to use dates in custom format or real dates in excel or text date or gen date? All these didn't work actually. What else then?

Save Follow Follow forum Report
Reply New topic

4 replies

Oldest first
  1. 0
    Raymund de Laza ·
    #1

    Hi Ferdinand, You need to use

    Hi Ferdinand,

    You need to use a real dates but have to input a constraints type CS_MANDSTART on the primary constraint type column and input also the corresponding start date in the Primary constraint date.

     

    Hope this will help.

     

    Regards,

    Report
  2. 0
    D Artagnan ·
    #2

    you can use the P6

    you can use the P6 import-export utility or SDK...

    Report
  3. 0
    Ferdinand Ancheta ·
    #3

    thanks raymund...but in this

    thanks raymund...but in this case you don't need the finish dates instead, Start & Durations.

    Report
  4. 0
    Raymund de Laza ·
    #4

    Ferdinand, Yes you are right.

    Ferdinand,

    Yes you are right. And make sure on the login sheet tab set the "View Durations In" matching with the duration you entered.

     

    Regards,

    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?