Skip Navigation

[Résolu] How to filter dates in a view

This support ticket is created Il y a 3 années et 5 mois. 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.

Aucun de nos assistants n'est disponible aujourd'hui sur le forum Jeu d'outils. Veuillez créer un ticket, et nous nous le traiterons dès notre prochaine connexion. Merci de votre compréhension.

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: Africa/Casablanca (GMT+01:00)

Ce sujet contient 5 réponses, a 2 voix.

Dernière mise à jour par fred-r.M Il y a 3 années et 5 mois.

Assisté par: Jamal.

Auteur
Publications
#2071567

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? lien caché

What is the link to your site? lien caché

#2071745

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 lien caché 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. **

#2072371

Thank you for the credentials. The view did not have any existing query filters as you can see in this screenshot lien caché 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 lien caché
And this screenshot of the results lien caché

I hope this helps. Let me know if you have any questions.

#2072629

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

#2072631

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

#2074179

My issue is resolved now. Thank you!

Ce ticket est maintenant fermé. Si vous êtes un client de Toolset et que vous avez besoin d'aide, veuillez ouvrir un nouveau ticket d'assistance