Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Summing Date Diff according to annual anniversary

Topic Labels: Dates & Timezones Formulas
310 1
cancel
Showing results for 
Search instead for 
Did you mean: 
zvarghese
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1

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