Baselined ?

[Robert]

Hi,
I tried to create an enterprise custom field (Entity = Project), Type: Flag,
with a quite simple formula:
IIf([Baseline Start]=ProjDateValue('NA'),False,True)
But the calculated value always stays at "No" while the project has a
baseline.
What did I missed?
Thanks

 

[Rod Gill]

This works for me in Project 2007 SP1:
IIf([Baseline Start]=ProjDateValue("NA"),False,True)

Maybe you just need double instead of single quotes.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Robert]

Rod,
I tried you formula (Enterprise custom field in PWA) with double quotes but
the result is always the same : No, while actually there is a baseline :-(

This works for me in Project 2007 SP1:
IIf([Baseline Start]=ProjDateValue("NA"),False,True)

Maybe you just need double instead of single quotes.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Hi,
I tried to create an enterprise custom field (Entity = Project), Type:
Flag, with a quite simple formula:
IIf([Baseline Start]=ProjDateValue('NA'),False,True)
But the calculated value always stays at "No" while the project has a
baseline.
What did I missed?
Thanks

 

[Rod Gill]

So what version of Project and what service pack level as this works for me?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Rod,
I tried you formula (Enterprise custom field in PWA) with double quotes
but the result is always the same : No, while actually there is a baseline
:-(

This works for me in Project 2007 SP1:
IIf([Baseline Start]=ProjDateValue("NA"),False,True)

Maybe you just need double instead of single quotes.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Hi,
I tried to create an enterprise custom field (Entity = Project), Type:
Flag, with a quite simple formula:
IIf([Baseline Start]=ProjDateValue('NA'),False,True)
But the calculated value always stays at "No" while the project has a
baseline.
What did I missed?
Thanks

 

[Robert]

I'm using Project Server 2007 (English) with SP1, but my Windows Server 2003
is French.

So what version of Project and what service pack level as this works for
me?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Rod,
I tried you formula (Enterprise custom field in PWA) with double quotes
but the result is always the same : No, while actually there is a
baseline :-(

This works for me in Project 2007 SP1:
IIf([Baseline Start]=ProjDateValue("NA"),False,True)

Maybe you just need double instead of single quotes.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Hi,
I tried to create an enterprise custom field (Entity = Project), Type:
Flag, with a quite simple formula:
IIf([Baseline Start]=ProjDateValue('NA'),False,True)
But the calculated value always stays at "No" while the project has a
baseline.
What did I missed?
Thanks

 

[Gary L. Chefetz]

Robert:

Are you republishing your project after recalculating the schedule in the
Project client? If not, try that.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

I'm using Project Server 2007 (English) with SP1, but my Windows Server
2003 is French.

So what version of Project and what service pack level as this works for
me?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Rod,
I tried you formula (Enterprise custom field in PWA) with double quotes
but the result is always the same : No, while actually there is a
baseline :-(

"Rod Gill" <rodATproject-systemsDOTcoDOTnz> a écrit dans le message de
news: (e-mail address removed)...
This works for me in Project 2007 SP1:
IIf([Baseline Start]=ProjDateValue("NA"),False,True)

Maybe you just need double instead of single quotes.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Hi,
I tried to create an enterprise custom field (Entity = Project), Type:
Flag, with a quite simple formula:
IIf([Baseline Start]=ProjDateValue('NA'),False,True)
But the calculated value always stays at "No" while the project has a
baseline.
What did I missed?
Thanks

 

[Robert]

Gary,

Yes I did that, without any success :-(

Robert:

Are you republishing your project after recalculating the schedule in the
Project client? If not, try that.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

I'm using Project Server 2007 (English) with SP1, but my Windows Server
2003 is French.

So what version of Project and what service pack level as this works for
me?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Rod,
I tried you formula (Enterprise custom field in PWA) with double quotes
but the result is always the same : No, while actually there is a
baseline :-(

"Rod Gill" <rodATproject-systemsDOTcoDOTnz> a écrit dans le message de
news: (e-mail address removed)...
This works for me in Project 2007 SP1:
IIf([Baseline Start]=ProjDateValue("NA"),False,True)

Maybe you just need double instead of single quotes.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Hi,
I tried to create an enterprise custom field (Entity = Project),
Type: Flag, with a quite simple formula:
IIf([Baseline Start]=ProjDateValue('NA'),False,True)
But the calculated value always stays at "No" while the project has a
baseline.
What did I missed?
Thanks

 

[Rod Gill]

Ok, just to tick the box, there is a date in the Baseline Start column?
Either apply the Tracking Table or insert the Baseline Start column to see
it.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Gary,

Yes I did that, without any success :-(

Robert:

Are you republishing your project after recalculating the schedule in the
Project client? If not, try that.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

I'm using Project Server 2007 (English) with SP1, but my Windows Server
2003 is French.

"Rod Gill" <rodATproject-systemsDOTcoDOTnz> a écrit dans le message de
news: (e-mail address removed)...
So what version of Project and what service pack level as this works
for me?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Rod,
I tried you formula (Enterprise custom field in PWA) with double
quotes but the result is always the same : No, while actually there is
a baseline :-(

"Rod Gill" <rodATproject-systemsDOTcoDOTnz> a écrit dans le message de
news: (e-mail address removed)...
This works for me in Project 2007 SP1:
IIf([Baseline Start]=ProjDateValue("NA"),False,True)

Maybe you just need double instead of single quotes.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Hi,
I tried to create an enterprise custom field (Entity = Project),
Type: Flag, with a quite simple formula:
IIf([Baseline Start]=ProjDateValue('NA'),False,True)
But the calculated value always stays at "No" while the project has
a baseline.
What did I missed?
Thanks

 

[Robert]

Yes Rod, there is a date in the Baseline Start column ;-)

Ok, just to tick the box, there is a date in the Baseline Start column?
Either apply the Tracking Table or insert the Baseline Start column to see
it.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Gary,

Yes I did that, without any success :-(

Robert:

Are you republishing your project after recalculating the schedule in
the Project client? If not, try that.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com


I'm using Project Server 2007 (English) with SP1, but my Windows Server
2003 is French.

"Rod Gill" <rodATproject-systemsDOTcoDOTnz> a écrit dans le message de
news: (e-mail address removed)...
So what version of Project and what service pack level as this works
for me?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Rod,
I tried you formula (Enterprise custom field in PWA) with double
quotes but the result is always the same : No, while actually there
is a baseline :-(

"Rod Gill" <rodATproject-systemsDOTcoDOTnz> a écrit dans le message
de news: (e-mail address removed)...
This works for me in Project 2007 SP1:
IIf([Baseline Start]=ProjDateValue("NA"),False,True)

Maybe you just need double instead of single quotes.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Hi,
I tried to create an enterprise custom field (Entity = Project),
Type: Flag, with a quite simple formula:
IIf([Baseline Start]=ProjDateValue('NA'),False,True)
But the calculated value always stays at "No" while the project has
a baseline.
What did I missed?
Thanks

 

[Robert]

On the other hand, I have another server with the French version of Project
Server 2007 SP1 :
The formula IIf([Début planifié]=ProjDateValue('NC');False;True) works
perfectly.
So I suspect a problem in the queueing process on my English server.
Thanks for your help,

Robert

Ok, just to tick the box, there is a date in the Baseline Start column?
Either apply the Tracking Table or insert the Baseline Start column to see
it.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Gary,

Yes I did that, without any success :-(

Robert:

Are you republishing your project after recalculating the schedule in
the Project client? If not, try that.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com


I'm using Project Server 2007 (English) with SP1, but my Windows Server
2003 is French.

"Rod Gill" <rodATproject-systemsDOTcoDOTnz> a écrit dans le message de
news: (e-mail address removed)...
So what version of Project and what service pack level as this works
for me?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Rod,
I tried you formula (Enterprise custom field in PWA) with double
quotes but the result is always the same : No, while actually there
is a baseline :-(

"Rod Gill" <rodATproject-systemsDOTcoDOTnz> a écrit dans le message
de news: (e-mail address removed)...
This works for me in Project 2007 SP1:
IIf([Baseline Start]=ProjDateValue("NA"),False,True)

Maybe you just need double instead of single quotes.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Hi,
I tried to create an enterprise custom field (Entity = Project),
Type: Flag, with a quite simple formula:
IIf([Baseline Start]=ProjDateValue('NA'),False,True)
But the calculated value always stays at "No" while the project has
a baseline.
What did I missed?
Thanks

 

[Robert]

I'm not far from the explanation of the solution:
When I deleted an old Enterprise custom field created before the SP1, at
this time 90% of the formulas turned out to be something like
ProjDateAdd([MSPJ188776463];[MSPJ188776458]) where field names where
replaced by strange numbers, my new formula worked well !!! ;-)
What is the interference between the 2 fields?

On the other hand, I have another server with the French version of
Project Server 2007 SP1 :
The formula IIf([Début planifié]=ProjDateValue('NC');False;True) works
perfectly.
So I suspect a problem in the queueing process on my English server.
Thanks for your help,

Robert

Ok, just to tick the box, there is a date in the Baseline Start column?
Either apply the Tracking Table or insert the Baseline Start column to
see it.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Gary,

Yes I did that, without any success :-(

"Gary L. Chefetz" <[email protected]> a écrit dans le message de
news: (e-mail address removed)...
Robert:

Are you republishing your project after recalculating the schedule in
the Project client? If not, try that.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com


I'm using Project Server 2007 (English) with SP1, but my Windows
Server 2003 is French.

"Rod Gill" <rodATproject-systemsDOTcoDOTnz> a écrit dans le message de
news: (e-mail address removed)...
So what version of Project and what service pack level as this works
for me?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Rod,
I tried you formula (Enterprise custom field in PWA) with double
quotes but the result is always the same : No, while actually there
is a baseline :-(

"Rod Gill" <rodATproject-systemsDOTcoDOTnz> a écrit dans le message
de news: (e-mail address removed)...
This works for me in Project 2007 SP1:
IIf([Baseline Start]=ProjDateValue("NA"),False,True)

Maybe you just need double instead of single quotes.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Hi,
I tried to create an enterprise custom field (Entity = Project),
Type: Flag, with a quite simple formula:
IIf([Baseline Start]=ProjDateValue('NA'),False,True)
But the calculated value always stays at "No" while the project
has a baseline.
What did I missed?
Thanks

 

[Gary L. Chefetz]

This looks like bug behavior corrected in one of the recent updates.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

I'm not far from the explanation of the solution:
When I deleted an old Enterprise custom field created before the SP1, at
this time 90% of the formulas turned out to be something like
ProjDateAdd([MSPJ188776463];[MSPJ188776458]) where field names where
replaced by strange numbers, my new formula worked well !!! ;-)
What is the interference between the 2 fields?

On the other hand, I have another server with the French version of
Project Server 2007 SP1 :
The formula IIf([Début planifié]=ProjDateValue('NC');False;True) works
perfectly.
So I suspect a problem in the queueing process on my English server.
Thanks for your help,

Robert

Ok, just to tick the box, there is a date in the Baseline Start column?
Either apply the Tracking Table or insert the Baseline Start column to
see it.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Gary,

Yes I did that, without any success :-(

"Gary L. Chefetz" <[email protected]> a écrit dans le message de
news: (e-mail address removed)...
Robert:

Are you republishing your project after recalculating the schedule in
the Project client? If not, try that.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com


I'm using Project Server 2007 (English) with SP1, but my Windows
Server 2003 is French.

"Rod Gill" <rodATproject-systemsDOTcoDOTnz> a écrit dans le message
de news: (e-mail address removed)...
So what version of Project and what service pack level as this works
for me?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Rod,
I tried you formula (Enterprise custom field in PWA) with double
quotes but the result is always the same : No, while actually there
is a baseline :-(

"Rod Gill" <rodATproject-systemsDOTcoDOTnz> a écrit dans le message
de news: (e-mail address removed)...
This works for me in Project 2007 SP1:
IIf([Baseline Start]=ProjDateValue("NA"),False,True)

Maybe you just need double instead of single quotes.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Hi,
I tried to create an enterprise custom field (Entity = Project),
Type: Flag, with a quite simple formula:
IIf([Baseline Start]=ProjDateValue('NA'),False,True)
But the calculated value always stays at "No" while the project
has a baseline.
What did I missed?
Thanks

 

[Lars]

Project uses a "global" references like e.g. [MSPJ188776463] at times when
there is a discrepancy in the regional settings applied between in your
Project Server and client or when there is applied other regional settings
for your Project Server than there is for your OS.

/Lars

This looks like bug behavior corrected in one of the recent updates.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

I'm not far from the explanation of the solution:
When I deleted an old Enterprise custom field created before the SP1, at
this time 90% of the formulas turned out to be something like
ProjDateAdd([MSPJ188776463];[MSPJ188776458]) where field names where
replaced by strange numbers, my new formula worked well !!! ;-)
What is the interference between the 2 fields?

On the other hand, I have another server with the French version of
Project Server 2007 SP1 :
The formula IIf([Dbut planifi]=ProjDateValue('NC');False;True) works
perfectly.
So I suspect a problem in the queueing process on my English server.
Thanks for your help,

Robert

"Rod Gill" <rodATproject-systemsDOTcoDOTnz> a crit dans le message de
news: (e-mail address removed)...
Ok, just to tick the box, there is a date in the Baseline Start column?
Either apply the Tracking Table or insert the Baseline Start column to
see it.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Gary,

Yes I did that, without any success :-(

"Gary L. Chefetz" <[email protected]> a crit dans le message de
news: (e-mail address removed)...
Robert:

Are you republishing your project after recalculating the schedule in
the Project client? If not, try that.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com


I'm using Project Server 2007 (English) with SP1, but my Windows
Server 2003 is French.

"Rod Gill" <rodATproject-systemsDOTcoDOTnz> a crit dans le message
de news: (e-mail address removed)...
So what version of Project and what service pack level as this works
for me?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Rod,
I tried you formula (Enterprise custom field in PWA) with double
quotes but the result is always the same : No, while actually there
is a baseline :-(

"Rod Gill" <rodATproject-systemsDOTcoDOTnz> a crit dans le message
de news: (e-mail address removed)...
This works for me in Project 2007 SP1:
IIf([Baseline Start]=ProjDateValue("NA"),False,True)

Maybe you just need double instead of single quotes.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Hi,
I tried to create an enterprise custom field (Entity = Project),
Type: Flag, with a quite simple formula:
IIf([Baseline Start]=ProjDateValue('NA'),False,True)
But the calculated value always stays at "No" while the project
has a baseline.
What did I missed?
Thanks