Calculate date diff between a tickets two assigne...

[zvarghese]

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?

[TheTimeSavingCo]

Hmm, perhaps try pulling the User Start Date into the Eent Request table, then create a formula field that checks whether that event is before the current anniversary?  Then update the field that calculates the duration to account for this new formula field and output 0 if it is