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?
Excel Dates to P6
Forum Sponsor
Top Posters
Neil Atkinson
5 posts
Trian Asmoro
1 posts
Soheil Barekat
4 posts
Erkan Polater
9 posts
Luis Jr Ngade
6 posts
Ben Welsher
1 posts
Rohan Dashputre
0 posts
AMECHI ANAKWENZE
2 posts
Jayaprakash Sekar
1 posts
arash.karmand
0 posts
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,
thanks raymund...but in this case you don't need the finish dates instead, Start & Durations.
you can use the P6 import-export utility or SDK...
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,