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))

      -1

       

      Any help is greatly appreciated!

       

      Thanks!