[SOLVED] Show Expiration Date in Member List

Hello - We use Comminity Builder and CBSubs to manage the membership in the United States Billiard Association ( www.usba.net )

For paid members in good standing we provide a membership list with search capability. Tournament Directors can look up a member to see if they are in good standing. We would like to display the "Expiration Date" of the member in the list. Presently the only field that is available in List Management is "Last Renewal" which is a bit misleading since we have members in different plans (1-year, 3-year, Life). The actual expiration date would be better information for a tournament director.

Can someone advise if it is possible to add the field "Expiration Date" from CBSubs into the feature List Management in CB. I know that there is some connection between CBSubs expiration date and CB member profile, because in My Profile on the Subscription tab I can see that date. I just cannot get to it in the List Management feature to permit display in a member list.

Thank you in advance for any assistance you can render.

You'd need to use a CB Query Field to query the database and grab the expiration date of their subscription. Example as follows.

Replace PLAN_ID_HERE with the id of the plan you want to check for an expiration date of.

Thank you... we are on our way having just installed the CB MySQL Field plugin.

"CB MySQL Field plugin" is not the same as "CB Query Field". Please ensure you've installed "CB Query Field". We did not develop "CB MySQL Field plugin".

We have 100% success in displaying the data we needed from CBSubs in the member list from CB. Thanks for pointing out this great feature.

We would like to make one more request:

Now we are able to display the expiry_date in its native format: 2015-02-19 18:47:27

Is it possible to limit that format to just the date part: 2015-02-19

... or better still... in the style our TD's are used to reading: 02-19-2015 (MM-DD-YYYY)

Thanks for your kind help once again.

Thank you... just to be clear... we are using the correct plug in (now!)... CB Query Field... Still looking to change the display format to date only (no time). Sorry for my earlier error.