I am working with student profiles for an academy. Each profile has a series of responsibilities we keep track of. Each responsibility has its own unique due date.
I need a find calculation for a server side script that returns any record that is less than or equal to 7 days from the approaching due date.
What would be the best approach to this.
Conclusion:
I need to create a find calculation within a server-side script that finds the records that are approaching a deadline (7 days before the deadline). Once found, the script will mark the status of the records as "Due."
But the day due differs for each different responsibility correct?
I would add a calculation field that uses the data you have here to calculate the date that it's due so that you can find all records where the date due is <= the current date.
Enrollment_Date + day_due might calculate that date. It depends on how weekends and holidays factor into how you calculate this. We work from a school calendar table in our system and thus can factor such details into our calculations by referencing that calendar table.