{"id":2408905,"date":"2022-07-01T06:34:10","date_gmt":"2022-07-01T06:34:10","guid":{"rendered":"https:\/\/toolset.com\/?post_type=course-lesson&p=2408905"},"modified":"2022-07-27T12:21:08","modified_gmt":"2022-07-27T12:21:08","slug":"filtering-toolset-views-by-dates","status":"publish","type":"course-lesson","link":"https:\/\/toolset.com\/de\/course-lesson\/filtering-toolset-views-by-dates\/","title":{"rendered":"Filtering Toolset Views by Dates"},"content":{"rendered":"\n

Views packs a powerful query filter that lets you search posts based on the date they were published, or even the date they were modified.<\/p>\n\n\n\n

To add a Post Date filter:<\/p>\n\n\n\n

  1. Select the main View<\/strong> block.<\/li>
  2. In the right sidebar, expand the Content Selection<\/strong> section.<\/li>
  3. Click on the Add a filter<\/strong> button, and select the Post date <\/strong>filter.<\/li><\/ol>\n\n\n
    \n
    \"\"<\/a>
    Filtering by post date<\/em><\/div><\/figcaption><\/figure>\n<\/div>\n\n\n

    You can filter posts by comparing the published <\/strong>or modified date<\/strong> against one or more values.<\/p>\n\n\n\n

    Compare Against a Date<\/a><\/h2>\n\n\n\n

    The default state is to filter posts by their date compared to one value. You can use the options to check whether the post date is equal to<\/strong>, different from<\/strong>, before (or equal) to<\/strong> or later (or equal) to<\/strong> a given date. You will be presented with a series of options to set the date to check against, including date<\/strong>, month <\/strong>and year<\/strong>.<\/p>\n\n\n\n

    Note that you have many options. You can set the usual year<\/strong>, month<\/strong>, day<\/strong>, hour<\/strong>, minute <\/strong>and second<\/strong>. But you can also set the day of the week<\/strong> or the day of the month<\/strong>. Watch out and do not try to get posts published on a Tuesday, April 13, 2015 because it was actually a Monday. \ud83d\ude42<\/p>\n\n\n\n

    Compare Against a Group of Dates<\/h2>\n\n\n\n

    You can also filter posts by comparing their dates against a set of values. Simply select to filter by dates in<\/strong>, not in<\/strong>, between<\/strong> or not between<\/strong> a set, and select the kind of date field to compare. For example, you can get posts published in 2012, 2013 and 2014:<\/p>\n\n\n

    \n
    \"\"<\/a>
    Filtering by date between two values<\/div><\/figcaption><\/figure>\n<\/div>\n\n\n

    Or you could get posts published in any day of the week but Saturday and Sunday:<\/p>\n\n\n

    \n
    \"\"<\/a>
    Filtering by days of the week<\/div><\/figcaption><\/figure>\n<\/div>\n\n\n

    Combine Conditions<\/h2>\n\n\n\n

    You can set more than one condition for this date query filter. At the bottom, you can set the logical relationship between conditions: AND<\/strong> (which will return posts meeting all conditions) or OR<\/strong> (which will return posts meeting at least one of the conditions).<\/p>\n\n\n\n

    For example, you could get posts that were published before January 1, 2015 and were published between 9:00am and 12:00 am and were also published on a weekday from Monday to Friday.<\/p>\n\n\n

    \n
    \"\"<\/a>
    Date query combination<\/div><\/figcaption><\/figure>\n<\/div>\n\n\n

    A Word on Values<\/h2>\n\n\n\n

    When filtering by a date value, you can set a fixed date, use variable values, or pass the value as a parameter to the View.<\/p>\n\n\n\n

    Variable values cover mainly three options: CURRENT_ONE<\/strong>, FUTURE_ONE<\/strong> and PAST_ONE<\/strong>.<\/p>\n\n\n\n

    CURRENT_ONE<\/strong> sets the value on the moment that the query is run, and is quite useful to get posts published this same year, month, or even day of the week.<\/p>\n\n\n\n

    FUTURE_ONE <\/strong>and PAST_ONE <\/strong>need a reach number. They can be used to get posts published last month, for example.<\/p>\n\n\n

    \n
    \"\"<\/a>
    Getting posts published last month<\/div><\/figcaption><\/figure>\n<\/div>\n\n\n

    Example 1:<\/strong> If a PAST_ONE<\/strong> value is used for the Year<\/strong> field and the numerical value is set to 2<\/strong> , then the View will display posts published two years ago (relative to the current year).<\/p>\n\n\n\n

    Example 2:<\/strong> If a FUTURE_ONE<\/strong> value is used for the Month <\/strong>field and the numerical value is set to 1<\/strong>, then we are filtering for posts published in the month after the current month, regardless of the year published.You can also set the values to come from external parameters, using a shortcode attribute or a URL parameter. Using a shortcode attribute will let you reuse the same View for several different filters. You can filter by year set by a shortcode attribute filteryear<\/strong>, as shown in the following image.<\/p>\n\n\n

    \n
    \"\"<\/a>
    Filtering by year using a shortcode attribute<\/div><\/figcaption><\/figure>\n<\/div>\n\n\n

    Then, you can load your View like this:<\/p>\n\n\n\n

    [wpv-view name=\"My View\" filteryear=\"2014\"]<\/code><\/pre>\n\n\n\n
    Here are the valid values for each date filter field:<\/p>\n\n\n\n