[Resolved] View with Posted Date to be yesterday and -3 days

[Author]

Posts

[andrewD-10]

Hi Toolset,

I would like one of my views to show posts that were published yesterday (before today at midnight) and between 3 days ago.

Video: hidden link

I may be confused on how to use the query filter; it seems I am doing something wrong.

Thank you,
Andrew

[Christian Cox]

It's best to use "between" instead of "equal to" here. For the last (n) days posts, you would want to set up the query filter to find posts publish date between days ago (n) and days ago (0). For yesterday - (3) days ago, you would want to set up the query filter to find posts between days ago (3) and days ago (1). Does this setting give you the results you expect?

[andrewD-10]

Hi Christian,

Thank you for your help thus far.

It seems to work ok, but still some issues. Although it is showing posts from 3 days ago it then skips to a different month and continues. This video will show it better: hidden link

I think it might still be looking for a day of the week rather than a past day.

Thank you,
Andrew

[Christian Cox]

I see, I think you should change "Day" in the Query Filter settings to "Day of the Year" to achieve something more like what you expect.

[andrewD-10]

Hi Christian,

That worked perfectly.

Now for another view, would you help me to show (-1) days post date and everything below?

Thank you,
Andrew

[Christian Cox]

In retrospect I think this still needs some tweaking to handle cases in the original View where:
- Some posts are more than a year old
- And/or the current date is January 1 - January 4
The GUI doesn't really give you the ability to handle all the little edge cases. I think this is a good opportunity to use a filter that allows more flexibility and handles both the original and new View queries. Here are two custom code snippets that can be applied in your child theme's functions.php file, or in a new code snippet in Toolset > Settings > Custom Code tab:

function tssupp_between_two_n_days_ago($view_args, $view_settings, $view_id)
{
    $view_ids = array( 123, 456 ); // Apply the 3-1 days ago filter to these View IDs

    if ( in_array($view_id, $view_ids) ) {

        $view_args['date_query'] = array(
            'after'     =>  '3 days ago',
            'before'    =>  '1 day ago',
            'column'    =>  'post_date'
        );
    }
    return $view_args;
}
add_filter('wpv_filter_query', 'tssupp_between_two_n_days_ago', 99, 3);


function tssupp_before_n_days_ago($view_args, $view_settings, $view_id)
{
    $view_ids = array( 234, 567 ); // Apply the older than yesterday filter to these View IDs

    if ( in_array($view_id, $view_ids) ) {

        $view_args['date_query'] = array(
            'before'    =>  '1 day ago',
            'column'    =>  'post_date'
        );
    }
    return $view_args;
}
add_filter('wpv_filter_query', 'tssupp_before_n_days_ago', 99, 3);

- Change 123, 456 to a comma-separated list of View IDs where you want to apply the "between 3 days ago and yesterday" filter.
- Change 234, 567 to a comma-separated list of the View IDs where you want to apply the "yesterday and older" filter.

Then you can remove the post date Query Filters from the Views where you want to apply these custom date filters. Let me know if this isn't working as expected and we can take a closer look.

References:
https://toolset.com/documentation/programmer-reference/views-filters/#wpv_filter_query
https://developer.wordpress.org/reference/classes/wp_query/#date-parameters

[andrewD-10]

Thank you Christian! I didn't use the code but instead used the query filter for posted date with the following condition: publish date is before - Day - Current one.

I will see how this works for now and use the code for future reference 🙂

Thank you,
Andrew