Skip to content

Start day & Finish day

Kris HarryMember for 22 years
Created
6
1
0
Hi Guys,

Can u guys let me know if we can show columns for start day and finish day - example day 120 as start day & day 125 as finish day for a 6 day activity and ow to do it.

Kris

6 replies

Oldest first
  1. 0
    Praves Suppa ·
    Hello Kris,

    Global change & CDI could help you for ordinal dates showing..

    Set CDIs for ordinal date of Staring Days and Finishing Day

    Run global change for...

    STARTDAY Equal ES - (the beginning day of the year.. ie year 1999 you have to choose 31 Dec 1998)

    FINISHDAY Equal EF - (the beginning day of the year.. ie year 1999 you have to choose 31 Dec 1998)

    Maybe a little help...

    Best Regards,
    Praves
  2. 0
    Kris Harry ·
    Thanks Praves,

    I’ll try what u have suggested. What is CDI. Can u give the steps for the global change u are suggesting.

    Kris
  3. 0
    Felis Muhammed ·
    Parves..

    Is that Custom Data Item???..if so, Kris u can find it on Menu->Data->Custom Data Item. Using that u can make columns for showing customised data. Think it is datailed in P3 help.

  4. 0
    Kris Harry ·
    Felis

    If it’s Custom Data Item (CDI), it will not be a calculated item and I cannot get the start day and finish day (for early and late dates) for various activities of the project.

    Kris
  5. 0
    Shamail Shardan ·
    Kris,

    From my side, i think its not possible, if you could do it, plz let post the method.

    Cheers
  6. 0
    Felis Muhammed ·
    Sorry guys..2 times i did the same mistake in posting and finaly am replying under this thread


    Just check if this is working

    Go Data->Custom Data Items (CDI)

    Add 3 CDI

    1) Name-ORDD , Type-S, length-7, Description-Ordinal data date
    2) Name-ORES , Type-N, length-7, Description-Ordinal ES
    3) Name-OREF , Type-N, length-7, Description-Ordinal EF

    Go Format-> columns
    Add the 3 CDI to display on the view

    Go Tools->Global change-> Add

    In the ‘then’ statement add ORDD EQ your reference date (use calendar from list)

    Trial run to see if it worked as per your wish and then run

    Go Tools->Project Utilities->Export

    Add new

    Include “Activity custom data items” to the list

    In the Format tab type the name of the file with location

    Select type as [.DBF]

    Run

    Go-Excel

    Open the exported DBF file in excel

    Format columns ORS & ORF in number format

    Use formula
    ORS= ES-ORDD
    ORF=EF-ORDD+1

    Drag down the formula columns till the last activities.

    Copy and paste the edited columns as values only.
    Save the dbf file & exit (should exit)
    go p3->Tools->Project Utilities->Import

    Enter the name of the exported file with extention [.DBF]

    Run

    This is manual method and not dynamic. Donno if some other easy methods are there. Any way back up b4 running. Welcome your comments

    Cheers

    Felis

Log in or join to reply

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

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