Obtain a list of new subscribers from the front end?

That works well. Thanks. Any way to download that user list as a file?

There's no functionality to download the results of a userlist.

Sorry, also how do I show only users joined since a certain date, say September 2023?

You can either add to the Advanced Filter to take into account their registration date or you can set the Register Date field to be searchable so you can just search the userlist at anytime with a date filter.

The problem is that a lot of users were imported in after their sub started on a previous site so the registerdate field isn't an accurate start date. The cb_substartdate field is custom htmI and only contains a calculation as follows:

[cbsubs:if user="#displayed" plan="1" status="A"] [cbsubs:subscriptions user="#displayed" plan="1" output="signup_date" /] [/cbsubs:if][cbsubs:if user="#displayed" plan="2" status="A"] [cbsubs:subscriptions user="#displayed" plan="2" output="signup_date" /] [/cbsubs:if][cbsubs:if user="#displayed" plan="3" status="A"] [cbsubs:subscriptions user="#displayed" plan="4" output="signup_date" /] [/cbsubs:if][cbsubs:if user="#displayed" plan="4" status="A"] [cbsubs:subscriptions user="#displayed" plan="4" output="signup_date" /] [/cbsubs:if][cbsubs:if user="#displayed" plan="9" status="A"] [cbsubs:subscriptions user="#displayed" plan="9" output="signup_date" /] [/cbsubs:if][cbsubs:if user="#displayed" plan="11" status="A"] [cbsubs:subscriptions user="#displayed" plan="11" output="signup_date" /] [/cbsubs:if][cbsubs:if user="#displayed" plan="14" status="A"] [cbsubs:subscriptions user="#displayed" plan="14" output="signup_date" /] [/cbsubs:if][cbsubs:if user="#displayed" plan="1" status="X"] [cbsubs:subscriptions user="#displayed" plan="1" output="signup_date" /] [/cbsubs:if][cbsubs:if user="#displayed" plan="2" status="X"] [cbsubs:subscriptions user="#displayed" plan="2" output="signup_date" /] [/cbsubs:if][cbsubs:if user="#displayed" plan="3" status="A"] [cbsubs:subscriptions user="#displayed" plan="4" output="signup_date" /] [/cbsubs:if][cbsubs:if user="#displayed" plan="4" status="X"] [cbsubs:subscriptions user="#displayed" plan="4" output="signup_date" /] [/cbsubs:if][cbsubs:if user="#displayed" plan="9" status="X"] [cbsubs:subscriptions user="#displayed" plan="9" output="signup_date" /] [/cbsubs:if][cbsubs:if user="#displayed" plan="11" status="X"] [cbsubs:subscriptions user="#displayed" plan="11" output="signup_date" /] [/cbsubs:if][cbsubs:if user="#displayed" plan="14" status="X"] [cbsubs:subscriptions user="#displayed" plan="14" output="signup_date" /] [/cbsubs:if]

Then you'll need to add to the Advanced Filter for that. Advanced Filter directly adds to the WHERE clause of the userlist query so you can add whatever SQL you need for your custom like. Advanced Sort adds directly to the ORDER BY clause of the userlist query. You've complete control over who it shows and in whatever order you want.

With my below post from earlier for example you can adjust it so it only returns users with a subscription date after a specific date.

www.joomlapolis.com/forum/professional-members-support/247364-obtain-a-list-of-new-subscribers-from-the-front-end?start=0#340469

Example as follows.

Active