4 Replies Latest reply on Jul 27, 2012 5:19 PM by ChristopherPayne

    Task Starter Solution - Days Until calculaiton error

    solventerprises

      Summary

      Task Starter Solution - Days Until calculaiton error

      Product

      FileMaker Pro

      Version

      12

      Operating system version

      n/a

      Description of the issue

      In the Tasks starter solution there is an error in the calculation in determining the number of days until a task is due.

      Steps to reproduce the problem

      Enter in any date in the future that happens either on a weekend or next week.

      Expected result

      Examples

      Today is 5/26/2012.

      1  Take out the trash   Due 5/28/2012  Result: 2 days
      2  Balance Checkbook Due 6/3/2012    Result: 8 days

      Actual result

      Today is 5/26/2012.

      1  Take out the trash   Due 5/28/2012  Result: 1 days
      2  Balance Checkbook Due 6/3/2012    Result: 5 days

      Exact text of any error message(s) that appear

      n/a

      Configuration information

      n/a

      Workaround

      It's only calculating business days. Since this Tasks solution includes categories of 'Personal' and 'Home' and not all businesses are closed on the weekends means that you shouldn't calculate just business days. Don't use the custom function 'GetWorkDays' in the calculated field `Days Till Due` and instead subtract the `Due Date` from Get ( CurrentDate ).

      task-issue-no2.png