Skip Navigation

[Resolved] Query by custom field date not functioning

This support ticket is created 5 years, 10 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

This topic contains 2 replies, has 3 voices.

Last updated by Luo Yang 5 years, 10 months ago.

Assisted by: Luo Yang.

Author
Posts
#1222827
Screen Shot 2019-03-28 at 7.40.41 PM.png

I am trying to:
I have multiple purchasable events, and each of them has a custom field for "Event Start Time" and I am trying to display each event grouped (with headers) by day (Friday, Saturday, etc...). I was trying to create a view to display all the Friday, May 31, 2019 events, which I will then duplicate, changing the date to match subsequently, but I cannot get the "query by date" function to produce results (see screenshot for how I am setting up the query.

Link to a page where the issue can be seen:
hidden link (un: flywheel pw: citd2019)

PLEASE NOTE: When I remove the query filter the events appear on the page, so I know the rest of the View is working correctly, I just can't get that query by date to show me only one date's worth of events.

#1222891

This works fine on my local test.
It must hence be either something with how the view is built, a setting in the view or date field I miss, or even a 3rd party plugin or theme.

Can you test this without any other plugin and another theme, and eventually also on a fresh (minimal) view?

If that does not help, please let me access the site so I can quickly check this.

#1223658

Thanks for the details, I can login into your website, and see the problem.

Please check the custom date field "Event Date" setting:
hidden link

It using option "Input date and time", so the actual field value will be:
May 31st 2019 ~ June 1st 2019

I have modified the date filter in your post view "Schedule - Friday", to below:
hidden link

Select items with field:
Event Date is a number between DATE(31, 05, 2019), DATE(01, 06, 2019)

Please test again, check if it is fixed.