Prev: Formula Finish Variance
Next: Project 2007 - Reset Task Durations
From: Marco on 5 Apr 2010 14:44
Hi everyone,

I have to subtract a custom duration field from the start field to get
an important information from my project.
When I try do to that like: "[Start]-[Duration4]" the result is a
totally confused date.
How do I get this date?

Best regards,

Marco Ferreira
From: Ismet Kocaman on 5 Apr 2010 17:03
Hello Marco,

Try the expression ProjDateSub([Start],[Duration4]).

Best Regards,
Ismet Kocaman
MCTS, PMP

"Marco" wrote:

> Hi everyone,
>
> I have to subtract a custom duration field from the start field to get
> an important information from my project.
> When I try do to that like: "[Start]-[Duration4]" the result is a
> totally confused date.
> How do I get this date?
>
> Best regards,
>
> Marco Ferreira
> .
>
From: Trevor Rabey on 6 Apr 2010 03:19
You can't subtract a duration from a date.
You can subtract a date from a date, or a duration from a duration.
That's why there are different data types.
Or you can use one of the datediff functions.
--
Trevor Rabey
0407213955
61 8 92727485
PERFECT PROJECT PLANNING
www.perfectproject.com.au

"Marco" <marcopf(a)gmail.com> wrote in message
news:4cb13f6d-89eb-4d8f-8af3-08a32f0b322c(a)k13g2000yqe.googlegroups.com...
> Hi everyone,
>
> I have to subtract a custom duration field from the start field to get
> an important information from my project.
> When I try do to that like: "[Start]-[Duration4]" the result is a
> totally confused date.
> How do I get this date?
>
> Best regards,
>
> Marco Ferreira


 | 
Pages: 1
Prev: Formula Finish Variance
Next: Project 2007 - Reset Task Durations