Reply To: Upcoming events are not getting displayed for time picker

• John Huebner

• February 9, 2022 at 3:39 pm

You’re question is a little confusing. It appears you are using to different fields “session_date” and “session_time”, is this correct?

If the current time is let’s say something like “14:30” and the next event starts at 8am tomorrow then the date then a
WHERE date > today & time > now would not return that post.

To do this you would need a nested meta query

'meta_query array(
  'relation' => 'OR',
  array(
    'key' => 'session_date',
    'value' => $today,
    'compare' => '>'
  ),
  array(
    'relation' => 'AND',
    array
      'key' => 'session_date',
      'value' => $today,
      'compare' => '='
    ),
    array
      'key' => 'session_time',
      'value' => $time,
      'compare' => '>'
    ),
  )
)

I don’t know why you are using clauses, the only purpose for them is to use them in your orderby.