AnsweredAssumed Answered

Task Starter Solution - Days Until calculaiton error

Question asked by solventerprises on May 26, 2012
Latest reply on Jul 27, 2012 by ChristopherPayne

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

Outcomes