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.
• This topic was modified 8 years, 10 months ago by cuviline.