WPBeginner

Beginner's Guide for WordPress

  • Blog
    • Beginners Guide
    • News
    • Opinion
    • Showcase
    • Themes
    • Tutorials
    • WordPress Plugins
  • Start Here
    • How to Start a Blog
    • Create a Website
    • Start an Online Store
    • Best Website Builder
    • Email Marketing
    • WordPress Hosting
    • Business Name Ideas
  • Deals
    • Bluehost Coupon
    • SiteGround Coupon
    • WP Engine Coupon
    • HostGator Coupon
    • Domain.com Coupon
    • Constant Contact
    • View All Deals »
  • Glossary
  • Videos
  • Products
X
☰
Beginner's Guide for WordPress / Start your WordPress Blog in minutes
Choosing the Best
WordPress Hosting
How to Easily
Install WordPress
Recommended
WordPress Plugins
View all Guides

WPBeginner» Blog» Tutorials» How to Sort Posts by Post Expiration Date in WordPress

How to Sort Posts by Post Expiration Date in WordPress

Last updated on October 22nd, 2013 by Editorial Staff
45 Shares
Share
Tweet
Share
Pin
Free WordPress Video Tutorials on YouTube by WPBeginner
How to Sort Posts by Post Expiration Date in WordPress

In the past, we have shared how to expire posts in WordPress using the Post Expirator Plugin. Well, when creating an event listing site, we found this plugin to be super helpful. We can easily delete the event listings that are expired. Secondly, thanks to this plugin, it is really easy to sort posts by post expiration date as well. In this article, we will show you how to sort posts by post expiration date in WordPress.

Code Updated to reflect the changes in the plugin where they changed the name of the custom field. Thanks Tajim for letting us know in the comments.

In our particular project, we had Events as a Custom Post Type. Now this is for a non-profit that holds like one event per month, so we simply created a loop to put in their events page. You can use the code in your sidebar, or anywhere else you want.

<?php
$args = array( 'post_type' => 'event', 'posts_per_page' => 15, 'order' => 'ASC', 'meta_key' => '_expiration-date', 'orderby' => 'meta_value' );
$eventloop = new WP_Query( $args );
if ( $eventloop->have_posts() ) : while ( $eventloop->have_posts() ) : $eventloop->the_post();

//All the Loop Content Goes Here

endwhile;
endif;
?>

The trick is to utilize the meta_key and then user oderby meta_value. Putting it in Ascending Order shows the event that is coming soon (expiring soonest). Example of our events listing:

Sort Posts by Post Expiration (Event Example)

Note in order for this to work, you MUST use the Post Expirator Plugin.

If you have any questions, feel free to ask in the comments below.

45 Shares
Share
Tweet
Share
Pin
Popular on WPBeginner Right Now!
  • Google Analytics in WordPress

    How to Install Google Analytics in WordPress for Beginners

  • How to Start Your Own Podcast (Step by Step)

    How to Start Your Own Podcast (Step by Step)

  • Revealed: Why Building an Email List is so Important Today (6 Reasons)

    Revealed: Why Building an Email List is so Important Today (6 Reasons)

  • Checklist

    Checklist: 15 Things You MUST DO Before Changing WordPress Themes

About the Editorial Staff

Editorial Staff at WPBeginner is a team of WordPress experts led by Syed Balkhi. Trusted by over 1.3 million readers worldwide.

The Ultimate WordPress Toolkit

24 Comments

Leave a Reply
  1. Francis Waller says:
    Sep 1, 2015 at 1:53 pm

    Hi, I’m trying to get this work on my woo commerce products which have to manipulated to be offsite courses which expire on a certain date. I really need to sort them by expiry date not sure what I’m doing wrong. Thanks

    Reply
  2. dtp says:
    Sep 30, 2014 at 9:58 am

    Is it possible to show the posts that end till next day or next week, month and so on.
    I want to create a site thats shows all posts that are ending next day. and one which is shwoing all post that are ending next week.

    Any suggestions?

    Reply
  3. James Parkin says:
    May 17, 2014 at 5:19 pm

    I have been trying to get this code to work with a Genesis Pro child theme. Made several posts with future dates. Add this code to sidebars via short codes and tried inside the functions.php file. Not using any custom fields or adding info.

    Any ideas would be appeciated

    Reply
  4. James says:
    May 17, 2014 at 5:06 pm

    I have been trying to get this to work to no avail. posted it in sidebar, function.php and as short codes. Any help would be appreciated.

    Reply
  5. James says:
    May 17, 2014 at 11:47 am

    I have not been able to get this to work with a Genesis Pro child theme. Added it to the last lines of the function.php file. added meta values too. unsure why it does not post in ASC order by expiration date.

    thank you in advanced

    Reply
  6. JP says:
    Mar 21, 2014 at 11:38 am

    Posts like this are why I love the internet (and blogs like yours). This is exactly what I was looking for and couldn’t have been laid out more simply. Thanks!

    Reply
  7. Dan says:
    Feb 13, 2014 at 5:40 pm

    Just what I was looking for – thanks!

    Reply
  8. Tajim says:
    Sep 16, 2013 at 4:44 am

    Just wanted to say that in current version of this plugin the custom field name has changed from
    expiration-date to _expiration-date.

    The custom field is hidden. So please update the code above.

    Regards
    Tajim

    Reply
  9. AMBA JUNIOR says:
    Jan 5, 2013 at 1:17 pm

    Thanks for this. Was wondering how you added the date images to the posts

    Reply
    • Editorial Staff says:
      Jan 10, 2013 at 10:54 am

      We pulled the meta information that this plugin stores in the post custom fields. Then styled it. That was a background CSS image and text overlay.

      Reply
      • Amba Junior says:
        Jan 15, 2013 at 8:29 am

        Thanks for the feedback. Would it be OK to get a sample code from you on this? Thanks in advance.

        Reply
        • Editorial Staff says:
          Jan 16, 2013 at 12:49 pm

          Unfortunately, we don’t offer that as part of our free service. You are more than welcome to hire us to write a custom snippet for you.

  10. Steve Combes says:
    Nov 2, 2012 at 6:17 pm

    Thanks for the great post.

    If I wanted to echo the post expiration date in the loop what code might I use?

    Reply
    • Editorial Staff says:
      Nov 6, 2012 at 10:25 am

      You would need to use the get_post_meta function and call the meta key “expiration-date”

      Example would be something like this:

      $expdate = get_post_meta($post->ID, 'expiration-date', true);
      echo $expdate;
      
      Reply
      • Adam says:
        Mar 3, 2014 at 8:32 pm

        I changed it to ‘_expiration-date’ and I’m getting the data, but how would you re-sort this into the correct date display? My date is March 1st 2015 and what’s echoed is “1425254340”

        Thanks,

        Reply
  11. Kitsts says:
    Sep 19, 2012 at 2:05 pm

    So for a total beginner, where would I put this code for it to sort by expiration?

    Reply
    • Editorial Staff says:
      Sep 20, 2012 at 7:53 am

      This article is not for total beginners. Because you have to have fair understanding of how WordPress themes work in order to make this code work with your specific theme.

      Reply
      • CuriousObserver says:
        May 16, 2013 at 3:10 pm

        If this isn’t for beginners, why did you post it to wpbeginner.com? I, too, am having difficulty inserting this into my blog and would like to see an answer to KITSTS’ question.

        Reply
        • Editorial Staff says:
          May 22, 2013 at 6:37 am

          Here at WPBeginner, we define beginners into various levels. Beginner blogger aka total beginner (just starting to blog, doesn’t know what is RSS, FTP etc). Beginner theme designer (knows HTML+CSS, but has no idea how to build themes in WordPress). Beginner plugin developer (knows the general concept around programming, but not specific to WordPress).

          The reason why we can’t answer KITST’ question is because it is impossible to answer with the information provided. The code shared in the article is a standard WordPress loop. Where you paste it in your theme will vary based on your needs and also the type of theme you are using.

          If you are using a child theme, then most likely that code will end up in your functions.php file, so you can hook it into the function provided by the theme framework.

          If you are using another WordPress theme, then the code can go in various different template files (index.php, sidebar.php, archive.php, archive-{posttype}.php, footer.php, header.php, etc). Each theme is organized differently which makes it impossible for us to give you an exact location where to paste this code.

          Also note, that the loop that we shared above is from an example work that we created using a custom post type called events. You may not want to use it for a custom post type events. Perhaps you want to use it for a different post type called deals.

          This article was intended for beginner theme designers and/or beginner developers who are looking for an easy way to do this.

  12. G J says:
    Jul 10, 2012 at 5:31 pm

    I was wondering, which plugin is used for displaying the upcoming events in the example above?
    Thanks for a lovely article…

    Reply
    • Editorial Staff says:
      Jul 11, 2012 at 9:23 am

      That wasn’t a plugin. It was just custom styling a custom post type display using the loop code that we shared in this article.

      Reply
      • G J says:
        Jul 18, 2012 at 9:53 am

        Ahhh..ok, is it possible for you to give an example on “All the Loop Content Goes Here” I am updating the webpage of a NGO and kind of liked this way of displaying the events on. As you may have noticed I am a beginner so I would really appreciate your help ;o)….

        Reply
        • Editorial Staff says:
          Jul 18, 2012 at 10:08 am

          The loop code essentially is the_title(); php tag to show the title. Another custom field to show the date. The loop is explained pretty well here:

          http://codex.wordpress.org/The_Loop

          We used styling (div/images/css) to make it look that way. This post is about how to sort posts by expiration date, and the article shows just that. The example used is something that we did for our client, so unfortunately we cannot share the images/styling that they paid for. Send us an email if you are interested in having us do this for you. We have special non-profit rates.

  13. Jacko says:
    Mar 22, 2012 at 9:10 am

    This is a cool feature.  There are several situations where this is what you need to be doing.
     
     
    PS
    This website has one of my favorite designs.  The #IBCT is about finding the best blogger in the world. Your website has made it to the semis.

    Reply

Leave a Reply Cancel reply

Thanks for choosing to leave a comment. Please keep in mind that all comments are moderated according to our comment policy, and your email address will NOT be published. Please Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.

Over 1,320,000+ Readers

Get fresh content from WPBeginner

Featured WordPress Plugin
TrustPulse
TrustPulse
Instantly get 15% more conversions with social proof. Learn More »
How to Start a Blog How to Start a Blog
I need help with ...
Starting a
Blog
WordPress
Performance
WordPress
Security
WordPress
SEO
WordPress
Errors
Building an
Online Store
Useful WordPress Guides
    • 7 Best WordPress Backup Plugins Compared (Pros and Cons)
    • How to Fix the Error Establishing a Database Connection in WordPress
    • Why You Need a CDN for your WordPress Blog? [Infographic]
    • 30 Legit Ways to Make Money Online Blogging with WordPress
    • Self Hosted WordPress.org vs. Free WordPress.com [Infograph]
    • Free Recording: WordPress Workshop for Beginners
    • 24 Must Have WordPress Plugins for Business Websites
    • How to Properly Move Your Blog from WordPress.com to WordPress.org
    • 5 Best Contact Form Plugins for WordPress Compared
    • Which is the Best WordPress Popup Plugin? (Comparison)
    • Best WooCommerce Hosting in 2021 (Comparison)
    • How to Fix the Internal Server Error in WordPress
    • How to Install WordPress - Complete WordPress Installation Tutorial
    • Why You Should Start Building an Email List Right Away
    • How to Properly Move WordPress to a New Domain Without Losing SEO
    • How to Choose the Best WordPress Hosting for Your Website
    • How to Choose the Best Blogging Platform (Comparison)
    • WordPress Tutorials - 200+ Step by Step WordPress Tutorials
    • 5 Best WordPress Ecommerce Plugins Compared
    • 5 Best WordPress Membership Plugins (Compared)
    • 7 Best Email Marketing Services for Small Business (2021)
    • How to Choose the Best Domain Registrar (Compared)
    • The Truth About Shared WordPress Web Hosting
    • When Do You Really Need Managed WordPress Hosting?
    • 5 Best Drag and Drop WordPress Page Builders Compared
    • How to Switch from Blogger to WordPress without Losing Google Rankings
    • How to Properly Switch From Wix to WordPress (Step by Step)
    • How to Properly Move from Weebly to WordPress (Step by Step)
    • Do You Really Need a VPS? Best WordPress VPS Hosting Compared
    • How to Properly Move from Squarespace to WordPress
    • How to Register a Domain Name (+ tip to get it for FREE)
    • HostGator Review - An Honest Look at Speed & Uptime (2021)
    • SiteGround Reviews from 4464 Users & Our Experts (2021)
    • Bluehost Review from Real Users + Performance Stats (2021)
    • How Much Does It Really Cost to Build a WordPress Website?
    • How to Create an Email Newsletter the RIGHT WAY (Step by Step)
    • Free Business Name Generator (A.I Powered)
    • How to Create a Free Business Email Address in 5 Minutes (Step by Step)
    • How to Install Google Analytics in WordPress for Beginners
    • How to Move WordPress to a New Host or Server With No Downtime
    • Why is WordPress Free? What are the Costs? What is the Catch?
    • How to Make a Website in 2021 – Step by Step Guide
Deals & Coupons (view all)
Keep Your WordPress Content Safe with BackupBuddy
BackupBuddy Coupon
Get 25% off BackupBuddy, the best and most popular WordPress backup plugin.
ShowThemes
ShowThemes Coupon
Get 20% off on ShowThemes beautiful WordPress themes for event websites.
Featured In
About WPBeginner®

WPBeginner is a free WordPress resource site for Beginners. WPBeginner was founded in July 2009 by Syed Balkhi. The main goal of this site is to provide quality tips, tricks, hacks, and other WordPress resources that allows WordPress beginners to improve their site(s).

Join our team: We are Hiring!

Site Links
  • About Us
  • Contact Us
  • FTC Disclosure
  • Privacy Policy
  • Terms of Service
  • Free Blog Setup
  • Free Business Tools
  • Growth Fund
Our Sites
  • OptinMonster
  • MonsterInsights
  • WPForms
  • SeedProd
  • Nameboy
  • RafflePress
  • Smash Balloon
  • AIOSEO

Copyright © 2009 - 2021 WPBeginner LLC. All Rights Reserved. WPBeginner® is a registered trademark.

Managed by Awesome Motive | WordPress hosting by SiteGround | WordPress Security by Sucuri.