Thread

Using EE syntax is there any way to achieve something similar to PHP’s date_diff function to work out the number of days between two given dates (in this case, the current_time and the expiry date of an entry)?

I want to do something similar to this pseudo-code:

{if current_time > (expiration_date - 30 days)}
do something date related
{/if}

I’ve searched devot-ee and there doesn’t seem to be any plugins out there that will do this, which surprises me.

Hi, David. There is an EE1.x plugin http://devot-ee.com/add-ons/timesince/ that might get you started, or I can move this over to the CodeShare Corner.

Basically, you’ll need to do some PHP code to do the math for the thirty days part.

Hey Sue,

That doesn’t really help me as I need to work out the difference in the background rather than as displayed HTML so I’ll go ahead and create my own solution.

Cheers

David

Hi David,

When you say “work out the difference in the background rather than as displayed HTML” what exactly do you mean by that?

The plugin that Sue has linked to, although it might not be exactly what you need works in the kind of way you have shown using your code above. Perhaps you can show some more code of exactly what you’re trying to achieve as it might be that a plugin could be created to do what you need here.

Best wishes,

Mark

Hi Mark

Okay, specifically I’m referring to the use of the Membrr subscriptions module for and the renewal date.

I want to be able to check if the current day is within 30 days of the subscription end date so I can show a subs renewal link. The end date is stored in standard “yyyy-mm-dd hh:mm:ss” format.

I could do it using a custom SQL query but I just wondered if there was a way to do it with EE sytax.

Does that make sense?

David

Hi David,

Yep that makes sense although in that case I do think that you are going to need to use some PHP to get at what you want then. That or create a plugin to handle it. Of course the plugin would be the same PHP as you’d have in a template but would just make things a bit neater.

Best wishes,

Mark

David,

To concur, some PHP here is the way to go. The Membrr guys might be able to give you this or it may already be in their forums somewhere