Skip to content

project schedule presentation with start date as zero.

Vijayasarathi RaviMember for 14 years 2 months
Created
2
4
0

Hi! all,

My Client wants the project schedule to be displayed with the start date value as zero.

Is there any way to do this other than by exporting the data to Excel and then formatting the date range?

2 replies

Oldest first
  1. 0
    Bo Johnsen ·

    Yes, you can do it both for

    Yes, you can do it both for the timescale and the start/finish dates.

    Timescale: choose "days" for units and then "1,2,3,4..(From Start)" under label

    Start/Finish dates: here you need to add 2 custom durations field (or number fields), one for start and one for finish. Now add a formula for each field e.g. by using the built-in function "ProjDateDiff". The formula for the start date would be:

    ProjDateDiff([Project Start];[Start])

    assuming you have a 7 days /week calendar assigned as project calendar and similar for the finish:

    ProjDateDiff([Project Start];[Finish])

    Otherwise you just modify the above formula with respect to which calendar you want assigned (see MSP help).

    You could also just do it by [Start]-[Project Start] but then you have to multiply with working minutes per day (e.g. 480 if 8 hours working day) and so on.

    Regards,

    Bo

  2. 0
    Vijayasarathi Ravi ·

    Bo,thank you for your

    Bo,

    thank you for your valuable suggestion. i have tried changing the timescale and done it successfully.

    I will inform you as and when I implement the function.

     

    thanks again,

    Vijay

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?