• Mathew Arcilla
  • 0 Points
  • Member since 2019

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
  • 0
I'm trying to build out a field that counts days while a condition is true. It's intended to count tenure while the customer is in an active membership.

We do have variables for the start date and end date of the membership which counts tenure of that specific membership, but we can't just use that because if the customer discontinues their membership and picks up a new membership at a later time, they'll start at the tenure they previously had. Another issue is they can have multiple memberships active at the same time so it can't be a tally of ALL membership tenures. 

Essentially I need it to be this psuedocode:

AT 12:00AM, IF ActiveMembership >0 THEN TenureDayCounter=TenureDayCounter+1.

Does this make sense? Hoping for some pointers here. 

Thanks in advance for your help.