WordPress.org

1. Chris Mason
   Member
   Posted 1 year ago #

   Hi, having some problems.

   I have 4 custom post types each containing approx 8 meta fields. In each custom post type there is a field that contains a date as dd/mm/yyyy.

   What i am trying to do is remove posts that contain a meta date field with a date past todays date.

   I really am lost any help would be appreciated.

   My custom post types are 'ukhol', 'holabroad', 'specevent' & 'daybreak'
   My date meta fields are 'ukhol_ddate_meta', 'holabroad_ddate_meta', 'specevent_ddate_meta' & 'daybreak_ddate_meta'
   The relevenat fields match the relevant post types ('ukhol_ddate_meta' is in custom post type 'ukhol')

   I have tried so many different ways that i have started working backwards!

2. vtxyzzy
   Member
   Posted 1 year ago #

   First, it is very difficult to compare dates unless they are in the format yyyy-mm-dd.

   Did you want SQL code to remove the posts so you could use phpMyAdmin or a similar tool? Or, do you want to not retrieve those dates in a query, but retrieve others (I think this is what you mean)? That is, only retrieve posts where those dates are in the future.

   And, by 'past todays date' do you mean the date is earlier than today?

3. Chris Mason
   Member
   Posted 1 year ago #

   I guess the date could be changed around before the query.

   What i am trying to do is list all custom posts that have the custom date field stating a date after the current date. Basically i have a list of holidays and once the departure date for the holiday has passed i no longer need them to be listed, the idea being the posts are still there but wont be visable until an admin changes the dates for the next time that holiday will take place, then it will re appear in the listing with the ammended date.

   The holidays come under 4 different custom post types as explained earlier and each carries a departure date "ukhol_ddate_meta" (for the ukhol post type).

   Hope that makes sense.

   I have all my custom post types defined in my function.php file and my post list is in my index.php file, i have a line of code in my function.php which allows posts, ukhol, holabroad, specevent & daybreak post types to be visible when viewing the index.php, which works fine, i just need to ommit any holidays thats departure date has passed.

4. vtxyzzy
   Member
   Posted 1 year ago #

   If the date fields are in yyyy-mm-dd format, the posts can be listed with a query like this (I can't test this so watch for typos):

   $today = date('Y-m-d');
   $args = array(
      'post_type' => 'ukhol',
      'meta_key' => 'ukhol_ddate_meta',
      'meta_value => $today,
      'meta_compare' => '>',
      'posts_per_page' => -1
   );
   query_posts($args);
   if (have_posts()) {
      while (have_posts()) {
         the_post();
         //  Put code here to display the poat
      }
   } else {
      // Put code here for 'no posts found'
   }

Topic Closed

This topic has been closed to new replies.