Filtering on future dated items

Hi,

I have a set up a date field to show when a sports fixture is to be held (“fixture_date”). I then want to only display future events, so in the shortcode I have included the where condition as follows, based on another post I found on here…

where="CAST( fixture_date.meta_value AS DATETIME ) >= NOW()"

However, this is not working – no posts are listed at all. Without the where clause, all posts are listed. Please advise me where I’m going wrong!

Thanks

Stephen

• This topic was modified 3 weeks, 6 days ago by sdcbmthsch.