Title: Query by date
Last modified: July 5, 2017

---

# Query by date

 *  [cuviline](https://wordpress.org/support/users/cuviline/)
 * (@cuviline)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/query-by-date/)
 * Hello ! its posible create custom queries for display expiration post by date?
 * Today, this week, this month…
 * Example :
 *     ```
       switch ($date) {
               case 'today':
                   return array(
                       'key'       => '_expiration-date',
                       'value'     => date('Y-m-d',strtotime("today")),
                       'compare'   => '=',
                       'type'      => 'DATE'
                   );
                   break;
   
               case 'this-week':
                   return array(
                       'key'       => '_expiration-date',
                       'value'     => array(date('YYYY-MM-DD',strtotime("Monday this week"), date('YYYY-MM-DD',strtotime("Sunday this week")))),
                       'compare'   => 'BETWEEN',
                       'type'      => 'DATE'
                   );
                   break;
                case 'this-month':
                   return array(
                       'key'       => '_expiration-date',
                       'value'     => array(date('YYYY-MM-DD',strtotime("Monday this week"), date('YYYY-MM-DD',strtotime("Sunday this week")))),
                       'compare'   => 'BETWEEN',
                       'type'      => 'DATE'
                   );
                   break;
           }
       ```
   
    -  This topic was modified 8 years, 10 months ago by [cuviline](https://wordpress.org/support/users/cuviline/).
    -  This topic was modified 8 years, 10 months ago by [cuviline](https://wordpress.org/support/users/cuviline/).

Viewing 1 replies (of 1 total)

 *  [Aaron Axelsen](https://wordpress.org/support/users/axelseaa/)
 * (@axelseaa)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/query-by-date/#post-9317881)
 * The value is stored as a GMT/UTC timestamp value in the post meta data. Keep 
   the timezone in mind when setting up your query. So if you craft your query correctly,
   I don’t know why it wouldn’t work.
 * Good Luck!

Viewing 1 replies (of 1 total)

The topic ‘Query by date’ is closed to new replies.

 * ![](https://ps.w.org/post-expirator/assets/icon-256x256.png?rev=3118683)
 * [Schedule Post Changes With PublishPress Future: Unpublish, Delete, Change Status, Trash, Change Categories](https://wordpress.org/plugins/post-expirator/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/post-expirator/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/post-expirator/)
 * [Active Topics](https://wordpress.org/support/plugin/post-expirator/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/post-expirator/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/post-expirator/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Aaron Axelsen](https://wordpress.org/support/users/axelseaa/)
 * Last activity: [8 years, 10 months ago](https://wordpress.org/support/topic/query-by-date/#post-9317881)
 * Status: not resolved