next due date / nearest due date
Our grants committee would like to be able to see when an organization's next report is due. Being able to include a merge field for next due date for follow-up reports would be really helpful.
I am currently running reports with Due Date (Follow Ups) as one of my data fields, then determining the next closest date, then manually adding to the summary. Am I missing an easier option? (GLM staff - see Focus Grant Summary merge template for an example.)