Title: Filtering on future dated items
Last modified: October 29, 2024

---

# Filtering on future dated items

 *  Resolved [sdcbmthsch](https://wordpress.org/support/users/sdcbmthsch/)
 * (@sdcbmthsch)
 * [1 year, 7 months ago](https://wordpress.org/support/topic/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 1 year, 7 months ago by [sdcbmthsch](https://wordpress.org/support/users/sdcbmthsch/).

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Support [pdclark](https://wordpress.org/support/users/pdclark/)
 * (@pdclark)
 * [1 year, 6 months ago](https://wordpress.org/support/topic/filtering-on-future-dated-items/#post-18131257)
 *     ```wp-block-code
       where="CAST( fixture_date.meta_value AS DATE ) >= CURDATE()"
       ```
   
 *  Thread Starter [sdcbmthsch](https://wordpress.org/support/users/sdcbmthsch/)
 * (@sdcbmthsch)
 * [1 year, 6 months ago](https://wordpress.org/support/topic/filtering-on-future-dated-items/#post-18131935)
 * Thanks! Will give this a go!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Filtering on future dated items’ is closed to new replies.

 * ![](https://ps.w.org/pods/assets/icon.svg?rev=3286397)
 * [Pods - Custom Content Types and Fields](https://wordpress.org/plugins/pods/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/pods/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/pods/)
 * [Active Topics](https://wordpress.org/support/plugin/pods/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/pods/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/pods/reviews/)

## Tags

 * [date](https://wordpress.org/support/topic-tag/date/)
 * [filter](https://wordpress.org/support/topic-tag/filter/)
 * [where](https://wordpress.org/support/topic-tag/where/)

 * 2 replies
 * 2 participants
 * Last reply from: [sdcbmthsch](https://wordpress.org/support/users/sdcbmthsch/)
 * Last activity: [1 year, 6 months ago](https://wordpress.org/support/topic/filtering-on-future-dated-items/#post-18131935)
 * Status: resolved