Date Completed. = Date last Completed.
Reoccurrence. = 3 (Meaning every 3 days.)
Next Due Date = Date last completed + the Reoccurrence value
How do I show the Next Due Date? [Reoccurrence]+[Date Completed] ?? Does not work.
Date Completed. = Date last Completed.
Reoccurrence. = 3 (Meaning every 3 days.)
Next Due Date = Date last completed + the Reoccurrence value
How do I show the Next Due Date? [Reoccurrence]+[Date Completed] ?? Does not work.
[Reoccurrence]+[Date Completed] should work if reoccurrence is a NUMBER and [date completed] is a DATE.
Yes they are,
I put this expression in a query under the Next Due Date field in criteria.
But am having no success.
what did you get while you said you have no success?
Got it, Needed to put the expression beside the field name not in criteria.