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

    LOD / Datediff calculation

    Terri English



      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 !