{"id":5031,"date":"2018-04-24T11:17:21","date_gmt":"2018-04-24T15:17:21","guid":{"rendered":"https:\/\/themespress.ca\/?p=5031"},"modified":"2022-10-01T14:32:38","modified_gmt":"2022-10-01T18:32:38","slug":"wordpress-query-display-post-type-results-with-two-date-fields","status":"publish","type":"post","link":"https:\/\/themespress.ca\/en\/wordpress-query-display-post-type-results-with-two-date-fields\/","title":{"rendered":"WordPress Query: Display Post Type Results with Two Date Fields"},"content":{"rendered":"
\n\t
\n\t\t
\n\t\t\t

With this tutorial, we want to return Post Type results with two date fields. In order to do so, we first need to create a Post Type. For our example, we already have a promotions<\/strong> Post Type. Within this Post Type, we’ve added a metabox with Two date type fields<\/strong>.<\/p>\n

Both Date type fields<\/strong> will contain the Date field (Metakey) for the event start date and end date. Here are both field IDs:start-date-promotion<\/strong> and end-date-promotion<\/strong>.<\/p>\n

With our Post Type and both fields with a specific date added, we need to initialize today’s date before our arguments so we can compare our meta query with the today’s date.<\/p>\n\n\t\t<\/div>\n\t<\/div>\n

Display Post Type Results with Two Date Fields.<\/h2>\n\t
\n\t\t
\n\t\t\t

(For our example, we display on-going promotions.)<\/p>\n\n\t\t<\/div>\n\t<\/div>\n

<?php \/\/ WP_Query arguments\n$today = date('Y-m-d');\n$args = array(\n  'post_type'         => array( 'promotions' ),\n  'meta_query'        => array(\n\tarray(\n\t'key'\t\t=> 'date-debut-promotion',\n\t'compare'\t=> '<=',\n\t'value'\t\t=> $today,\n        ),\n        array(\n\t'key'\t\t=> 'date-fin-promotion',\n\t'compare'\t=> '>=',\n\t'value'\t\t=> $today,\n\t)\n   ),\n);\n \n\/\/ The Query\n$query = new WP_Query( $args );\n\/\/ The Loop\nif ( $query->have_posts() ) {\nwhile ( $query->have_posts() ) { \n$query->the_post(); \n?>\n \n\/\/ Afficher votre loop ici\n \n<?php } } else { ?>\n<?php } ?>\t\n<?php wp_reset_postdata(); ?><\/pre><\/div>\n\t
\n\t\t
\n\t\t\t
So we have created a variable that stores today’s day and then we create our query and finally we assign a meta query or a date field start-date-promotion<\/strong> that needs to be lower or equal to today’s date and that the end-date-promotion<\/strong> is greater or equal than today’s date.<\/p>\n\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div><\/div><\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"With this tutorial, we want to return Post Type results with two date fields. In order to do so, we first need to create a Post Type. For our example,
Read More<\/a><\/div>","protected":false},"author":81,"featured_media":5034,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[283],"tags":[],"class_list":["post-5031","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/posts\/5031","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/users\/81"}],"replies":[{"embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/comments?post=5031"}],"version-history":[{"count":0,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/posts\/5031\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/media\/5034"}],"wp:attachment":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/media?parent=5031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/categories?post=5031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/tags?post=5031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}