none
ProjDateDiff Calculation Problem RRS feed

  • Question

  • Hello,

    i have touble with a formula on PWA

    successfully I have brought online this

    a Custom Field, entity task, type duration, formula  ProjDateDiff([Start]; [task_T.COS])

    [Start] is the out of the box

    [task_T.COS] is another custom field, entity task, type duration

    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

    ProjDateDiff([Start]; [task_T.COS]) + 1

    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

Answers

  • put the plus1 in the brackets

    ProjDateDiff([Start]+1; [task_T.COS])

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

    might help somebody else


    • Edited by Olof Hansen Friday, February 8, 2019 12:21 PM
    • Proposed as answer by Olof Hansen Friday, February 8, 2019 12:23 PM
    • Unproposed as answer by Olof Hansen Friday, February 8, 2019 12:23 PM
    • Marked as answer by loffloff 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
    Moderator
  • Hi Barbara

    Thank you for your answer.

    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

    ProjDateDiff([Start]+1; [task_T.COS])

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

    might help somebody else


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