# ProjDateDiff Calculation Problem

• ### Question

• Hello,

i have touble with a formula on PWA

successfully I have brought online this

[Start] is the out of the box

result in a special case is 1d (plus one day)

so far so good.

But I have to manipulate the calculation by 1 day, the result has to be one day more, it should be 2d

so i changed the formula to

Result is 0d, as well when i put there a +2 or something else.

So something doesn´t work with my new formula with the +1 or +2

Does anybody know what is the mistake?

Thursday, February 7, 2019 3:30 PM

• put the plus1 in the brackets

another thing, which was a problem in the past:  " ; " is needed, not " , "

might help somebody else

• Edited by Friday, February 8, 2019 12:21 PM
• Proposed as answer by Friday, February 8, 2019 12:23 PM
• Unproposed as answer by Friday, February 8, 2019 12:23 PM
• Marked as answer by Friday, February 8, 2019 12:29 PM
Friday, February 8, 2019 12:20 PM

### All replies

• Hi,

1 day = 480 (min) with 8h/day and 60min/hour.

ProjDateDiff([Start],[Date1],[Project Calendar])+2*480

Does that work better?

Barbara

Thursday, February 7, 2019 4:13 PM
• Hi Barbara

Unfortunately not.

In a different context i found out that if you calculate Date minus Date in a custom field with type duration it calculates the value with a "d" and there is no need for conversion with 480.

/480 or something like that is needed if number or text is the type

i found your an older question from you - that´s why i startet the test with duration, number and text.

in this case i used the date/duration combination, so i got the 1d

but adding something gives back nothing oder 0d in edit mode - no matter if i add +1 or +2 or +1*480 or +2*480

Thursday, February 7, 2019 4:54 PM
• put the plus1 in the brackets