{"id":6286,"date":"2016-08-13T13:52:25","date_gmt":"2016-08-13T17:52:25","guid":{"rendered":"https:\/\/themespress.ca\/?p=6286"},"modified":"2022-09-08T19:06:01","modified_gmt":"2022-09-08T23:06:01","slug":"query-post-type-comparing-two-dates","status":"publish","type":"post","link":"https:\/\/themespress.ca\/en\/query-post-type-comparing-two-dates\/","title":{"rendered":"Create a Query Post Type Between Two Dates"},"content":{"rendered":"
\n\t
\n\t\t
\n\t\t\t

With this tutorial, we will show you a date based query post type stemming from a post meta. Here’s an example of a WP Query<\/a>.<\/p>\n

First step is to create a post meta date which fetches the date value. For example, we have created a post meta called informations_videos_release_date<\/strong>.<\/p>\n

Now we will create a query that will display all the post type published between two specific dates. Meaning that for our exmaple, we will display the videos published between the two selected dates. <\/p>\n

We will display videos between 1980 et 1989 by using a comparative meta query comparing to Post Meta Key values.<\/p>\n

We could also create a form that would fetch the data between both dates and instead of using 1980 and 1989, we would recuperate the form data.<\/p>\n\n\t\t<\/div>\n\t<\/div>\n

Create a Query Post Type Between Two Dates<\/h2>
<?php \n\/\/ Première valeur de date comparative \n$start = '1980'; \n\/\/ Deuxième valeur de date comparative \n$end = '1989'; \n\/\/ Nous commençons l'affichage \n$semaine = new WP_Query( \narray( \n'post_type'                  => 'viavideos', \n'post_status'                => 'publish',\n'meta_key'                   => 'informations_vidos_date_de_sortie',\n'showposts'                  => '200',\n'orderby'                    => 'rand',\n'paged'                      => $paged,\n'order'                      => 'DESC', \n'meta_query'                 => array(\n    array(\n    \/\/ On appelle la meta key désirée et on compare entre les deux valeurs issus des deux variables\n\t\t'key'       => 'informations_vidos_date_de_sortie',\n\t\t'value'     => array($start, $end),\n\t\t'compare'   => 'BETWEEN',\n\t)\n    )\n));\nwhile ( $semaine->have_posts() ) : $semaine->the_post();\n?>\n\n\/\/\/\/ Votre loop ici \/\/\/\/\n\n<?php wp_reset_query(); ?>\n<?php endwhile; ?><\/pre><\/div><\/div><\/div><\/div><\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"With this tutorial, we will show you a date based query post type stemming from a post meta. Here's an example of a WP Query. First step is to create
Read More<\/a><\/div>","protected":false},"author":81,"featured_media":4538,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[283],"tags":[322],"class_list":["post-6286","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-query"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/posts\/6286","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=6286"}],"version-history":[{"count":0,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/posts\/6286\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/media\/4538"}],"wp:attachment":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/media?parent=6286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/categories?post=6286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/tags?post=6286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}