Start day & Finish day

Member for

19 years 3 months

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

Member for

19 years 9 months

Kris,



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



Cheers

Member for

21 years 1 month

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

Member for

19 years 3 months

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.


Member for

21 years 1 month

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

Member for

19 years 5 months

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