DateAdd formual

[Dana]

Why doesn't this work as a custome forumla in Date2 field?

DateAdd("M",3,[Deadline])

or this

DateAdd("d",90,[Deadline])

I'm trying to put a custom formula in Date2 that adds 90 days to the
existing Deadline for the task and calculates a new date.

 

[JulieS]

Hi Dana,

Can you give more information about *what* you see when you try it.
I've just placed your formula in a date field in the Gantt chart view,
entry table and it calculated correctly.

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

Julie
Project MVP

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

 

[Dana]

I see NA.

I think the problem is with the format of the date in the Deadline field
that I'm add to, becasue if I just try to make Date2 = Deadline with
[Deadline] in the formula, that doesn't work either. It still says N/A.

Is there a special data format that's required? I'm using Jul 17 '08

Thanks

Hi Dana,

Can you give more information about *what* you see when you try it.
I've just placed your formula in a date field in the Gantt chart view,
entry table and it calculated correctly.

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

Julie
Project MVP

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

Why doesn't this work as a custome forumla in Date2 field?

DateAdd("M",3,[Deadline])

or this

DateAdd("d",90,[Deadline])

I'm trying to put a custom formula in Date2 that adds 90 days to the
existing Deadline for the task and calculates a new date.

 

[JulieS]

Hi Dana,

Your formula will return an error if there is no deadline in the
[Deadline] field -- try the following formula in the date field:

IIf([Deadline]=ProjDateValue("NA"),ProjDateValue("NA"),DateAdd("d",90,[Deadline]))

The formula will return NA if there is no deadline set. If there is a
deadline, the Date2 field will show 90 working days beyond the
deadline date.

If you want to calculate the value for summary tasks, make sure you
select the option "Use formula" for summary and grouping rows.

The format of the date is not an issue.

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

Julie
Project MVP

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

I see NA.

I think the problem is with the format of the date in the Deadline
field
that I'm add to, becasue if I just try to make Date2 = Deadline with
[Deadline] in the formula, that doesn't work either. It still says
N/A.

Is there a special data format that's required? I'm using Jul 17
'08

Thanks

Hi Dana,

Can you give more information about *what* you see when you try it.
I've just placed your formula in a date field in the Gantt chart
view,
entry table and it calculated correctly.

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

Julie
Project MVP

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

Why doesn't this work as a custome forumla in Date2 field?

DateAdd("M",3,[Deadline])

or this

DateAdd("d",90,[Deadline])

I'm trying to put a custom formula in Date2 that adds 90 days to
the
existing Deadline for the task and calculates a new date.

 

[JulieS]

Hi Dana,

It looks like my reply to you from yesterday got lost, so here it is again:

Your formula will return an error if there is no deadline in the
[Deadline] field -- try the following formula in the date field:

IIf([Deadline]=ProjDateValue("NA"),ProjDateValue("NA"),DateAdd("d",90,[Deadline]))

The formula will return NA if there is no deadline set. If there is a
deadline, the Date2 field will show 90 working days beyond the
deadline date.

If you want to calculate the value for summary tasks, make sure you
select the option "Use formula" for summary and grouping rows.

The format of the date is not an issue.

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

Julie
Project MVP

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

I see NA.

I think the problem is with the format of the date in the Deadline field
that I'm add to, becasue if I just try to make Date2 = Deadline with
[Deadline] in the formula, that doesn't work either. It still says N/A.

Is there a special data format that's required? I'm using Jul 17 '08

Thanks

Hi Dana,

Can you give more information about *what* you see when you try it.
I've just placed your formula in a date field in the Gantt chart view,
entry table and it calculated correctly.

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

Julie
Project MVP

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

Why doesn't this work as a custome forumla in Date2 field?

DateAdd("M",3,[Deadline])

or this

DateAdd("d",90,[Deadline])

I'm trying to put a custom formula in Date2 that adds 90 days to the
existing Deadline for the task and calculates a new date.