Skip to content

Importing Excel Dates to P5

Kylie FergusonMember for 18 years 9 months
Created
4
1
0
I am having problems when importing dates from an excel spreadsheet into P5. The dates are coming across on the data date, even though the activity dates are in the future. Does anyone know how to hold the dates so they come across as per those in excel ?

4 replies

Oldest first
  1. 0
    Mark Chapman ·
    I don’t use this facility but I suspect the key thing here is to ensure you have the correct durations and logic then let the software calculate the dates remembering you need to configure a calendar too and this where discrepancies can occur.
  2. 0
    Kylie Ferguson ·
    Thanks Mark for your advice. I have in fact fixed the problem, this is how. Export the project with a primary constraint & primary constraint date field. Enter the dates in the excel spreadsheet into the primary constraint date column and enter a Start On constraint in the constraint column. When you import, the dates come across in the constraint field, hit schedule and the start dates are then reflected as per the constraint dates.
  3. 0
    Sandy Matheson ·
    So you are not using logic relationships to determine start dates?
  4. 0
    Kylie Ferguson ·
    That’s correct.

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?