Context:
I have two different tables: A User Info table, and an Event Request table. the relevant columns User Start Date, Event Start Date and Event End Date.
Current Status:
I am calculating the duration of the events in the Event Request table, pulling it into the User Info table and summing it to calculate total event duration per user.
Issue:
I want that event duration to reset after passing anniversaries of the user's start date. Any thoughts?
