Format of Date and DateAdd function

[wiredlowrider]

I am currently trying to create a custom field with a formula to give me the
current date + 1 month.

I was using this formula dataAdd("d",30,date())
however since that was giving me "NA" I was trying to see if it was getting
a system date and it doesn't appear to be.

Any suggestions for my syntax?

 

[JulieS]

Hi wiredlowrider,

I am able to get today's date plus 30 days by using your formula in a
custom date field.

I was also able to use
DateAdd("d",30,Now())

Are you using a date field?

--
I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for FAQs and more information about
Microsoft Project.

 

[wiredlowrider]

Part II - It turns out that the code is correct however there is a radio
button that needed to be checked "use formula" for all tasks. However I have
linked in multiple sub projects and none of them have the newly added custom
columns so I have to add each one to the other projects. If there is a trick
to this please let me know.

 

[JulieS]

Hi wiredlowrider,

I'm not sure I follow exactly what you are searching for, but let my try
an explanation and see if that helps.

If you created a custom date field (Date1 for example) in several
project files, when you consolidate those projects into a master project
through Insert > Project, add the custom field to the master, the
formula will calculate at the subproject task level because that
calculated data belongs to the subproject file.

However, the Inserted Project Summary task will not calculate. You have
a couple of options:

1) Add the formula again to the field in the master project.
To make things easier (and cut the risk of typos), I would first open
one of the subproject files and copy the formula from the custom field.
(Right click and choose copy from the shortcut menu). Consolidate the
files, add the custom field to the master, customize the field and paste
in the formula. While you are in the Customize Fields dialog box,
select the "Use formula" option for "Calculation for task and group
summary rows".

2) If you have multiple customized fields, create the master project,
and open one of the subproject files that contains the customized
fields. From the subproject file, go to Tools > Organizer and copy the
custom field from the subproject to the master. This will copy the
formula in the custom field. You will still need to go to Customize
Fields and select the option for the task and group summary rows.

You may also use either method to copy formulas between project files of
any sort.

--
I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for FAQs and more information about
Microsoft Project.

"wiredlowrider" <
(e-mail address removed)> wrote in message