help with events expiring too soon on wordpress site (php neewbie)

peppybojagger

I'm using a theme which has code to display upcoming events on a page, but it is expiring the posts on the day of instead of the day after (or at midnight). Here's the part of the code:

<?php
$currenttime = date('Ymd');
$paged = ( get_query_var( 'paged' ) ) ? get_query_var( 'paged' ) : 1;
$args = array(
'post_type' => 'event',
'post_status' => 'publish',
'order' => 'ASC',
'orderby' => 'menu_order',
'posts_per_page' => 5,
'paged' => $paged,
'meta_query' => array(
array(
'key' => 'event_end_date',
'type' => 'DATE',
'value' => $currenttime,
'compare' => '>'
),
),
);

I tried changing "'compare' => '>'" to "'compare' => '>='" to no change, but works when I change it to less than. Thanks in advance!

Weedpacket

Perhaps if you added one day to when it is supposed to expire.

pbismad

What is the data type and format of your event_end_date field?

peppybojagger

Weedpacket;11055271 wrote:
Perhaps if you added one day to when it is supposed to expire.

Thanks for the suggestion. How would I do that? Is the expiration in the code already?

peppybojagger

In Custom Fields it says the type is 'Date Picker' and the format is 'yymmdd'

peppybojagger

Thanks for the suggestion. Is the expiration code present already?

Weedpacket

I don't know the code, but if you set when it is supposed to expire somewhere (that date picker), then you can set it yourself there (just pick the next day).

pbismad

peppybojagger;11055279 wrote:
In Custom Fields it says the type is 'Date Picker' and the format is 'yymmdd'

It would be interesting to see what the generated sql query statement is, but it's likely that your value string in the format of yyyymmdd won't compare correctly with the field contents.

If you change this line - $currenttime = date('Ymd');, to the following and use the '>=' comparison, it should work -

$currenttime = date('ymd'); // note the lower case 'y'

sneakyimp

I feel I should point out that "too soon" might be a matter of one's time zone. If your computer is in Greenwich, England and you are in California, then the time in each place is different. If you are getting complaints from your users about things expiring too soon, you might want to clarify that things expire at time XYZ in time zone PDQ.

Bonesnap

Time zones are an issue with WordPress - and setting the time zone in the back-end settings doesn't affect date or time calculations in your templates or files. I would take sneaky's advice and double-check that the time zones and related calculations are in order.