Making a list of old clients

[Silvijn]

Hi,

I have a list of all my clients, current and old. I want to make a list of clients that haven't renewed their subscription. I have the date their subscription ended. I think I need a variable date that is always equal to today, so I can have the filter to ''subscription ended before today''. 

Is there a way to do this?

Any help would be greatly appreciated,

Silvijn

[JessicaH]

Hi @Silvijn,

Thanks for reaching out.

This article might be a good starting point for you as it explains how you can determine your list criteria. 

This idea in our ideas forum regarding relative date filters might be interesting as well.

I hope this helps.

Take care!

Jess