Lifeseeker
Registered User.
- Local time
- Today, 04:49
- Joined
- Mar 18, 2011
- Messages
- 273
Hi,
I am having some trouble with this query. Users track issues by due_date. So for example, user wants to find out how many issues are due in 10 days, or in 14 day, etc, depending on the number of days they specify.
As you can see in the test database, I have a field set up that calculates the date difference between the due_date and now().
In the due_date field, the criteria is > [due in how many days].
The results are not returning the right entry.
any help/comment much appreciated.
I am having some trouble with this query. Users track issues by due_date. So for example, user wants to find out how many issues are due in 10 days, or in 14 day, etc, depending on the number of days they specify.
As you can see in the test database, I have a field set up that calculates the date difference between the due_date and now().
In the due_date field, the criteria is > [due in how many days].
The results are not returning the right entry.
any help/comment much appreciated.
