Profile: simonM-5

Problem:
the user is using a form with the expiration feature. He then queries posts on a view based on the expiration date. But he encounters some issues because the site is using a different timezone than UTC.

Solution:
Expiration dates are stored as timestamp, hence in the UTC timezone.

But the view's query using "NOW" and "SECONDS_FROM_NOW" are calculated in the site's timezone. We'll need to hook into the query and change these dates to UTC.

Check this sample code:

add_filter( 'wpv_filter_query', 'change_date_filters_for_expiring_jobs', 10, 3 );
  
function change_date_filters_for_expiring_jobs( $query_args, $view_settings, $view_id ) {
  // return $query_args;
  if ( $view_id == 10351) {
    $value = $query_args['meta_query'][0]['value'];
    $values = explode(",", $value);
    $value = ( ( (int) $values[0] ) - 7200 ) . "," . ( ((int) $values[1]) - 7200 );
    $query_args['meta_query'][0]['value'] = $value;
  }  
   
  return $query_args;
}

Note that this code assumes that there is only one meta_query on the view. If the view queries another custom field, this code should be modified and adapted