"Searching Dates in a Table" (#2942806) / TMS-Plugins

Comments

Alexander Harrington started the conversation
December 21, 2021 at 6:04pm
Hello. I'm playing around in the wpDataTables free trial sandbox using "Travel Agency Offers" as my data source. The table has columns for "Date" and "End Date." When I try to search the table for a specific date as it appears in one of those columns, the search returns "No Matching Records Found." Using the filtering fields works fine, but for the project I'm working on I'd also like to search dates whether by day, month, year, or just by year. I'm concerned being able to use the search box for some data but not for others will be too confusing for potential site viewers. How can I use the search feature for dates?
2,576
Aleksandar replied
December 27, 2021 at 9:02am
Hello Alexander
Thank you for your interest in our plugin and sorry for the late response.
The date columns can only use the date-range filter correctly while using any other filters (along with the global search) can return wrong or no results depending on the format of the dates, and the formats that you're using.
This issue has been forwarded to our developers, so they can look into it, and I hope they will be able to resolve it soon. I apologize for the inconvenience, but hopefully, this will be resolved in one of our future updates.
Kind Regards,

Aleksandar Vuković
[email protected]

Rate my support

wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs

Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community

You can try wpDataTables add-ons before purchasing on these sandbox sites:

Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables