8 Replies Latest reply on Aug 16, 2018 8:31 AM by Joe Oppelt

    Expected closing parenthesis for the expression starting at character 1

    Damon Bunn

      Hello.  I am still in the early stages of learning Desktop and I running into the error message above in this equation:


      (DATEDIFF('day',ATTR([Loan Events (3)].[Date Completed]),[Date Modified]) -

      (7-DATEPART('weekday',ATTR([Loan Events (3)].[Date Completed])) -

      DATEPART('weekday',[Date Modified])

      ) / 7*5

      + MIN(5,(7-(DATEPART('weekday',ATTR([Loan Events (3)].[Date Completed]))))

      + MIN(5,(DATEPART('weekday',[Date Modified])-1))



      Any help is greatly appreciated!