project schedule presentation with start date as zero.

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?

Microsoft Project
V
Vijayasarathi Ravi 👤 Member for 13 years 10 months
· Permalink

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

B
Bo Johnsen 👤 Member for 20 years 3 months
· Permalink

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

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts