Use double quotes or single quotes in formulas?

A

anovak

In formulas like this:

IIf([Baseline Finish]=projdatevalue('NA'),"No
baseline",IIf(ProjDateDiff([Baseline Finish],[Finish])/480>5,"Late by
more than 5 days",IIf(ProjDateDiff([Baseline Finish],[Finish])/
480>0,"Late","On schedule")))

Is it better to use double quotes or single quotes for values?
Seems like I heard at one time one approach will result in errors.

Also, why doesn't Project Professional allow you to create Project
Level custom fields without having to use PWA?

Thanks,
Andy Novak
UNT
 
J

Jack Dahlgren

I think there may be some dependence on language preferences, but I always
use double quotes in formulas and do not have any issues with them in US
English environments.

As for Project Server 2007 project level fields, perhaps they thought that
allowing administrators to create and edit custom fields without having to
use Project Pro? Or perhaps they are implemented within the database? It
would seem that somewhere they have a reasonable justification, but the
implementation is not as smooth as could be desired. Asking why is not all
that productive. :)

-Jack Dahlgren
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top