5 Replies Latest reply on Oct 11, 2018 7:41 AM by seraj alam

    LOD / Datediff calculation

    Terri English

      Guys

       

      As per screen dump below :-

       

      I'm trying to calculate 'Active Duration', which should be the difference in days from Work Start Date until Today.

       

      My calculation is DATEDIFF('day',[Work Start (Project Task V)],[Today])

       

      as you can see by the results it's clearly wrong, I'm guessing this needs to be a LOD fixed calculation on the Number column ? I've read a few posts but don't really understand what i need to do here ?

      Could someone kindly advise ?

       

       

      Thanks in advance !