[Resolved] Setting View to current month on initial page load

[Author]

Posts

[bobA-2]

Some time ago Minesh provided me support and the code below to remove past events from a view on initial page load. I was wondering if this can be modified to have the view show posts from the current month instead on initial page load?

So basically I am looking for a way to have posts shown with number equal to THIS_MONTH() on intial page load but still the user has to be able to choose other date range in a between filter with date pickers. I have no problem in setting up the latter but the initial load current month thing is the issue.

add_filter('wpv_filter_query', 'remove_past_events', 10, 3);
function remove_past_events($query_args, $view_settings, $view_id) {
   
if($view_id == 69798   && !isset( $_GET['wpv_view_count'] ))  {
$time = time();  
$query_args['meta_query'][] = array(array(
'key' => 'wpcf-program-tidspunkt',
'value' => $time,
'compare' => '>=',
'type' => 'NUMERIC,'
 ));
}
   
return $query_args;
}

[Luo Yang]

Dear Bob,

Please try this:

add_filter('wpv_filter_query', 'remove_past_events', 10, 3);
function remove_past_events($query_args, $view_settings, $view_id) {
    
	if($view_id == 69798   && !isset( $_GET['wpv_view_count'] ))  {
		$time = time(); 
		$this_month = strtotime(date('Y-m-01 00:00:00'));
		$query_args['meta_query'][] = array(array(
			'key' => 'wpcf-program-tidspunkt',
			'value' => array($this_month, $time),
			'compare' => 'BETWEEN',
			'type' => 'NUMERIC,'
		 ));
	}
    
return $query_args;
}

More help:
https://stackoverflow.com/questions/11236708/how-to-get-timestamp-of-current-month-first-day-of-month-zero-hour
https://codex.wordpress.org/Class_Reference/WP_Query#Custom_Field_Parameters

[bobA-2]

Thanks Luo. Works just fine.

[Luo Yang]

You are welcome

[bobA-2]

Hi again.

It seems the code you provided only shows current month up until now and not the complete month?

[bobA-2]

Found the solution:
Changed time to mktime(23, 59, 59, date("n"), date("t"));