Wrong results in View filtered by date if WordPress timezone is not UTC

This thread is resolved. Here is a description of the problem and solution.

Problem: I have a View with a post date Query Filter, set to display posts whose publish date is after or equal to: Minute: PAST_ONE(19). However, the filter doesn't seem to be working as expected when I change the WordPress timezone value. It works when set to UTC.

Solution: Check the Query Filter and make sure you have set the Year, Month, Day, and Hour criteria to CURRENT_ONE, otherwise, you will not get the expected results.

Relevant Documentation:
https://toolset.com/documentation/user-guides/date-filters/

This support ticket is created 6 years, 3 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.

This topic is split from https://toolset.com/forums/topic/delete-created-post-by-cred-commerce-on-cart-abandon-and-clear-cart/

Sun	Mon	Tue	Wed	Thu	Fri	Sat
8:00 – 12:00	8:00 – 12:00	8:00 – 12:00	8:00 – 12:00	8:00 – 12:00	-	-
13:00 – 17:00	13:00 – 17:00	13:00 – 17:00	13:00 – 17:00	13:00 – 17:00	-	-

Supporter timezone: America/New_York (GMT-04:00)

Tagged: Content-submission forms, CRED API, Forms with post relationships, Toolset Forms

This topic contains 5 replies, has 2 voices.

Last updated by ahmedh 6 years, 3 months ago.

Assisted by: Christian Cox.

Author

Posts

September 20, 2018 at 5:46 am #1112058

ahmedh

I successfully created a view in the checkout page to render the last created booking / pack post by the current user And set the post date filter as:

Select posts whose
Published date is after or equal to: minute:PAST_ONE(19)

in the Query filter.

The problem is when I set the general wordpress UTC to another country/location.
I currently set it to UTC 0 and the filter works well

Then I added that part:

[wpv-no-items-found]
<h1>Cart Cleared Try Again</h1>
[clear_cart]
[/wpv-no-items-found]

September 20, 2018 at 3:43 pm #1112343

Christian Cox

Screen Shot 2018-09-20 at 11.30.43 AM.png

Hi can you provide some additional information?
- Change the Query Filter to use "publish date GMT" instead of "publish date" and test again. Is the problem resolved? If not, continue.
- Which WP timezone setting did you choose?
- What is the PHP timezone setting? This is not necessarily the same as the WordPress timezone setting. If you are not sure, upload a phpinfo file as described in the "How to check the PHP version" section here: https://toolset.com/toolset-requirements/
Upload the file to your server then visit the file URL in your browser. Take a screenshot of the "date" section, like I have posted here. Share the screenshot in your next reply.

September 21, 2018 at 2:13 am #1112668

ahmedh

Hello Christian,

I tried both (post date / post date GMT) with no success.
I created a shortcode to make some conditions in the template to get around it. but the filter is not giving the expectation result

September 21, 2018 at 2:18 am #1112673

ahmedh

hidden link

September 23, 2018 at 1:46 pm #1113864

Christian Cox

Okay please select "CURRENT_ONE" in the post date filter for the following fields:
- Year
- Month
- Day
- Hour

September 23, 2018 at 8:47 pm #1113920

ahmedh

My issue is resolved now. Thank you!