Tell us what you are trying to do? We are having a custom post type "Tour Dates". The main field we are using there is Tour Date Field (Date format). The sorting in the view is working so far fine.
But now we like to show all dates starting today until the future. Having the filter this way:
- Tour Date Field is a DATE greater than NOW() - shows us the very first record.
- Tour Date Field is a DATE greater than TODAY() - shows us the very first record.
It seems as this filter isn't working as it should be...
Is there any documentation that you are following? https://toolset.com/documentation/user-guides/views/filtering-views-query-by-date/
Is there a similar example that we can see? hidden link
What is the link to your site? hidden link
Hello and thank you for contacting the Toolset support.
If I understand correctly, you wouldn't expect to get the first 2 posts in this screenshot hidden link right?
Would you allow me temporary access to check how the view and filters are setup? Your next reply will be private to let you share credentials safely. ** Make a database backup before sharing credentials. **
Thank you for the credentials. The view did not have any existing query filters as you can see in this screenshot hidden link Therefore, it will return all the posts that have a value for the field tour-date-field, because it is used for ordering.
I added a query filter on the "Tour Date Field" field and it worked as expected. The query filter needs to compare values as numbers. Check this screenshot hidden link
And this screenshot of the results hidden link
I hope this helps. Let me know if you have any questions.
Dear Jamal
Okay, great. I didn't know what to put in, so far. Is there a documentation I can follow - in the future?
Regards
Thank you! I am glad I could help.
Besides of the article that you have shared in your first message, we have this other article:
- https://toolset.com/documentation/user-guides/views/date-filters/
Unfortunately, all our documentation efforts are now moved toward Blocks editor. If you have any questions about the legacy views, just open a chat or a ticket here and we'll do our best to help.
For support rules, we are able to handle only one issue at a time. This helps us to bring you a better service and also helps other users to find all the information here exposed. If you think that your initial question has been answered, please mark this ticket as resolved and open a new chat or ticket for any other question/request.
All the best,
Jamal
My issue is resolved now. Thank you!
