How to only show future events

Hi

I have added some custom fields using ACFpro to posts in a specific category of events. I have created a page as a simple test area that simply shows the post title and the event date (custom field - field name = date_of_event). I have tried all sorts of date formats but i had originally used dd/mm/yyyy as both return format and display format. In the looper provider i have used query builder and used a Meta Value of date_of_event Greater than or equal to {{dc:global:date format=“d/m/Y”}}

no matter what options i use the event dated 28/01/2025 still displays in the list as can be seen on this test page https://denengelleek.co.uk/current-events/
I know dates can be a real pain to fix especially due to date formats but any hel pon resolving this and pointing me in the right direction would be much appreciated.

many thanks in advance

Hello @The_Capture_Factory,

Thanks for writing to us.

To help you with your concerns we need to check your settings, I would request please share the admin login details meanwhile I would suggest you troubleshoot a few of the common issues before we investigate your settings. Please share your details in a secure note. Please provide the following details

  • WordPress Login URL
  • Admin-level username and password
  • Exact page URL

You can find the Secure Note button at the bottom of your posts

Thanks

Hello @The_Capture_Factory ,

I would suggest you go to the page and change the meta value to this dynamic content code
{{dc:global:date format="Ymd"}} and recheck it.

Hope it helps
Thanks

Hi

That’s great, that has sorted it. Many thanks.

In the spirit of this forum helping others would it be possible for someone (when they have time) to explain why this worked when the display and returned field in ACF were set to dd/mm/yyyy. I know from previous experience that date formats in databases cause all sorts of problems but if we could understand why this fixed the issue i am sure it will help people in the future to not fall into the same trap.

many thanks for your help
Richard

Hi Richard,

Glad to know that it is sorted now.

Thanks