Problem with using ProjDateDiff

[jpa]

I am using PS2007 (evaluation version).
When using Project Pro 2007 (eval version) I managed to create a custom
field using formula like for instance ProjDateDiff([Start];[Current Date])/480
Now I want to create such a custom field at enterprise level using PWA. To
do so I create a new custom field from PWA: Server Settings->Enterprise
Data->Enterprise Custom Field Definition. I select same options (Task,Number)
and copy the formula as within Project Pro 2007 but I faced with following
errors
1) "The formula contains a syntax error or contains a reference to an
unrecognized field or function name"
2) then when opening again the field definition screen I noticed that field
names have been changed as following:
ProjDateDiff([MSPJ188743715],[MSPJ37748835])

I am a little bit lost...
Why does-it work with project pro and not with PWA?
thanks for your help

 

[Gérard Ducouret]

jpa,

It is probablibly a list separator issue:
http://support.microsoft.com/kb/927606/en-us

Hope this helps,



Gérard Ducouret

 

[Gary L. Chefetz [MVP]]

jpa:

It looks as though your SQL server is using the ";" semicolon as the list
separator. You need to set SQL server to use the "," comma as the list
separator. This will clear the problem.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[jpa]

Thank you for your fast reply
This solve the error message...
Now I still have issue about value et icon display within PWA view (subject
of another post)
jpa

jpa:

It looks as though your SQL server is using the ";" semicolon as the list
separator. You need to set SQL server to use the "," comma as the list
separator. This will clear the problem.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

I am using PS2007 (evaluation version).
When using Project Pro 2007 (eval version) I managed to create a custom
field using formula like for instance ProjDateDiff([Start];[Current
Date])/480
Now I want to create such a custom field at enterprise level using PWA. To
do so I create a new custom field from PWA: Server Settings->Enterprise
Data->Enterprise Custom Field Definition. I select same options
(Task,Number)
and copy the formula as within Project Pro 2007 but I faced with following
errors
1) "The formula contains a syntax error or contains a reference to an
unrecognized field or function name"
2) then when opening again the field definition screen I noticed that
field
names have been changed as following:
ProjDateDiff([MSPJ188743715],[MSPJ37748835])

I am a little bit lost...
Why does-it work with project pro and not with PWA?
thanks for your help

 

[Eduardo Ferreira]

Hello Gary,

I am facing this problem and I'd like to ask you if you can help me setting the SQL Server up in order to change the list separator.

My environment is:

Client side:
- Project Professional 2007 (Portuguese)
- Windows 7 (Portuguese)
- The List separator is set as semicolon (When I change this option on regional setting to comma I get a message from Project Professional warning me that list separator and decimal separator are the same)

Server side:
- PWA 2007 (English)
- Windows Server 2008 (English)
- The list separator is set to comma. I've already changed it to semicolon in regional settings but even so I didn't manage to get the formula working.

As you can see I have a peculiar installation right here and set SQL server is my last try before reinstall Windows Server and PWA in Portuguese.

Any help would be great.

Cheers,
Eduardo

I am using PS2007 (evaluation version).
When using Project Pro 2007 (eval version) I managed to create a custom
field using formula like for instance ProjDateDiff([Start];[Current Date])/480
Now I want to create such a custom field at enterprise level using PWA. To
do so I create a new custom field from PWA: Server Settings->Enterprise
Data->Enterprise Custom Field Definition. I select same options (Task,Number)
and copy the formula as within Project Pro 2007 but I faced with following
errors
1) "The formula contains a syntax error or contains a reference to an
unrecognized field or function name"
2) then when opening again the field definition screen I noticed that field
names have been changed as following:
ProjDateDiff([MSPJ188743715],[MSPJ37748835])

I am a little bit lost...
Why does-it work with project pro and not with PWA?
thanks for your help

On Tuesday, October 30, 2007 9:01 AM G?rard Ducouret wrote:
jpa,

It is probablibly a list separator issue:
http://support.microsoft.com/kb/927606/en-us

Hope this helps,



G?rard Ducouret



(e-mail address removed)...