I'm working on a weekly inspection application. The function I need will reset a date field based on the current date. But rather than resetting the next inspection date by one week, I need it to reset the date to whatever next Monday is.
Example: Today is Wednesday 24-SEP-14. On-submit should reset the next date to Monday 29-SEP-14, not 01-OCT-14.