Using substitutions to display message based on pending expiry date

I need to show a message to members whose expiry is within 30 days of today.

I can't even work out the logic for this and ended up with this which can't be right. What's the right syntax for the less than 30 days section?

[cbsubs:if user="#displayed" plan="4" status="A" and  "expiry_date"  <30 ]MESSAGE GOES HERE[/cbsubs:if]

Thanks

You'll need to use the "since" feature of the CBSubs substitutions. Edit the cbpaidsubsbot in System > Manage > Plugins and review its description for a more detailed explanation of CBSubs content plugin substitutions. With that said I believe the below should work.

You may need to adjust the operator on "since" to <= though, but give that a try first. Effectively the way it works is it modifies the expiration date by subtracting 30 days from it then compares it to the current datetime. So if the expiration date -30 days is >= to the current date then they're not about to expire in 30 days is effectively what the conditioning is saying.

Works a treat. Thanks.

OK, I might be missing something here but how do I enable this to show across the site? It only works on the CB profile page at present. I can't see any settings to change but I'm sure there was a setting at one point.

It works anywhere Joomla content plugins work. So you can only use it in such locations. For example in Joomla articles or in CB Content Module if the content plugins parameter is enabled or Custom HTML field if content plugins parameter is enabled.

Sorry but I can't get it displayed anywhere but the CB profile page. Example - the privacy policy page is a standard Joomla article. Publishing the module to that page on the same position also doesn't show it.