Skip Navigation

[Resolved] Between comparison returning wrong results on date filter

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

Problem:
A Views filter tests a date field to see if it occurs in a range between a start date and end date but doesn't return the matching posts.

Solution:
The dates have been added in the wrong order, the first date needs to be the earliest one and the second date the later one.

Relevant Documentation:
https://toolset.com/documentation/user-guides/filtering-views-query-by-date/

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

No supporters are available to work today on Toolset forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.

Sun Mon Tue Wed Thu Fri Sat
- 7:00 – 14:00 7:00 – 14:00 7:00 – 14:00 7:00 – 14:00 7:00 – 14:00 -
- 15:00 – 16:00 15:00 – 16:00 15:00 – 16:00 15:00 – 16:00 15:00 – 16:00 -

Supporter timezone: Europe/London (GMT+00:00)

Tagged: 

This topic contains 2 replies, has 2 voices.

Last updated by randallH-3 6 years, 9 months ago.

Assisted by: Nigel.

Author
Posts
#617263
Screen Shot 2018-02-19 at 9.39.50 AM.png
Count:  [wpv-found-count]

I'm getting the number of post counts for the past 30 days. See the screenshot of the filter. It outputs the wrong count.

#617355

Nigel
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+00:00)

Hi Randy

Is that View returning any results?

If you are using the between comparison, the first date needs to be the earliest one and the second date the later one.

It appears that you have entered them the other way around.

#619565

Thanks.