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.