Creating a False bar

[Andrew]

I am creating a bar to represent planned progress. I am using a duration
field with a formula to work out the planned duration. This works. so the bar
could start from the baseline start, I know the duration, but how do I set
the finish in bar styles?

Andrew

 

[Gérard Ducouret]

Andrew,

The "End" symbol in Bars Style doesn't do what you want?

Gérard Ducouret

 

[Dave]

You could use the Finish1 filed to represent the planned progress date
and populate it with your start date plus the duration.

I would also wonder whether built in functionality was not sufficient
but that is for you to determine.

Hope this helps.

Dave

 

[Andrew]

Gerard

Thanks for the quick response

What I meant is that I have a start date (baseline) I have a duration worked
out by formula as to how many days should have been completed to the status
date, but what I dont know how to do is arrive at an end date field that I
can add to the from and to section of the format bar styles.

Regards

Andrew

 

[Gérard Ducouret]

Andrew,

So use a custom field such as Finish(x) to display your calculated finish
date and use it in the Bar Styles dialog.

Gérard Ducouret

 

[Andrew]

I am using Planned % (a macro to get the %) x Baseline duration and I am
putting that information in a duration field Duration1. when I try to put a
formula in Finish Field, Finish1+Duration1 the resultant date runs out years
away, what am I doing wrong ?

Cheers

Andrew

 

[Jack Dahlgren MVP]

Duration is stored internally in minutes. So a one day duration is 480. Add
that to a date (dates are stored as serial numbers - today is 39842) and you
get a date far in the future.
Instead of adding the duration to the date, use either DateAdd or
ProjDateAdd.
ProjDateAdd uses the project calendar when adding so it handles working days
correctly.
DateAdd just does regular date math.

If Duration1 is 5days then
ProjDateAdd(Now(),[Duration1],"Standard") would give a date one work week
from today. (Thursday)
DateAdd( "d", 5, now()) would give a date five days from today (Tuesday)
Now()+[Duration1] would give a date in 2015

-Jack Dahlgren

 

[Andrew]

Jack

Thankyou very much - I understand how MSP works the dates out now, very useful

Andrew

Duration is stored internally in minutes. So a one day duration is 480. Add
that to a date (dates are stored as serial numbers - today is 39842) and you
get a date far in the future.
Instead of adding the duration to the date, use either DateAdd or
ProjDateAdd.
ProjDateAdd uses the project calendar when adding so it handles working days
correctly.
DateAdd just does regular date math.

If Duration1 is 5days then
ProjDateAdd(Now(),[Duration1],"Standard") would give a date one work week
from today. (Thursday)
DateAdd( "d", 5, now()) would give a date five days from today (Tuesday)
Now()+[Duration1] would give a date in 2015

-Jack Dahlgren

I am using Planned % (a macro to get the %) x Baseline duration and I am
putting that information in a duration field Duration1. when I try to put
a
formula in Finish Field, Finish1+Duration1 the resultant date runs out
years
away, what am I doing wrong ?

Cheers

Andrew