Title: Date search does not work Last modified: October 3, 2022 --- # Date search does not work * Resolved [gatestar](https://wordpress.org/support/users/gatestar/) * (@gatestar) * [3 years, 7 months ago](https://wordpress.org/support/topic/date-search-does-not-work/) * Hi I have an issue with the condition search on date field. The between function works fine but if I put equal and select a date nothing happens. * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdate-search-does-not-work%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 12 replies - 1 through 12 (of 12 total) * Thread Starter [gatestar](https://wordpress.org/support/users/gatestar/) * (@gatestar) * [3 years, 7 months ago](https://wordpress.org/support/topic/date-search-does-not-work/#post-16066482) * Also when I have added a search pane for one of my fields which is a text field the search pane does not appear. * Thread Starter [gatestar](https://wordpress.org/support/users/gatestar/) * (@gatestar) * [3 years, 7 months ago](https://wordpress.org/support/topic/date-search-does-not-work/#post-16066483) * Also just noticed the export csv icon is flashing with a question mark and exclamation mark. * Thanks sorry for all the things. * Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * (@peterschulznl) * [3 years, 7 months ago](https://wordpress.org/support/topic/date-search-does-not-work/#post-16068149) * Hi [@gatestar](https://wordpress.org/support/users/gatestar/), * Let’s go through your questions one by one… * >>> The between function works fine but if I put equal and select a date nothing happens. * Your date column is a datetime column. The value you select is of type date. This results in a comparison like: October 1, 2022 12:02 am === October 1, 2022 which is not true. * Do you need the time in your table? If not you could create a view and convert the datatime to date. This allows you to search for specific dates while maintained the time. * >>> Also when I have added a search pane for one of my fields which is a text field the search pane does not appear. * Did you add anhy columns? Please use the Config button behind the search panes checkbox. This is documented here: [https://wpdataaccess.com/docs/data-publisher/premium-extensions/](https://wpdataaccess.com/docs/data-publisher/premium-extensions/) * >>> Also just noticed the export csv icon is flashing with a question mark and exclamation mark. * Sorry, I don’t understand what you mean. Can you please clarify this? Maybe add a screenshot? * Thanks, Peter * Thread Starter [gatestar](https://wordpress.org/support/users/gatestar/) * (@gatestar) * [3 years, 7 months ago](https://wordpress.org/support/topic/date-search-does-not-work/#post-16068937) * Hi Thanks for the Reply, I am really close to everything being perfect. * I will respond to your responses. * ``` >>> The between function works fine but if I put equal and select a date nothing happens. Your date column is a datetime column. The value you select is of type date. This results in a comparison like: October 1, 2022 12:02 am === October 1, 2022 which is not true. >>>>>> The field is a date field not date time. Do you need the time in your table? If not you could create a view and convert the datatime to date. This allows you to search for specific dates while maintained the time. >>> Also when I have added a search pane for one of my fields which is a text field the search pane does not appear. >>>>>>> I have configured the search pane and added the column but will not show the front end. https://timesheet.sykesit.co.uk/pictures/search-pane-1.jpg Did you add anhy columns? Please use the Config button behind the search panes checkbox. This is documented here: https://wpdataaccess.com/docs/data-publisher/premium-extensions/ >>> Also just noticed the export csv icon is flashing with a question mark and exclamation mark. Sorry, I don’t understand what you mean. Can you please clarify this? Maybe add a screenshot? ``` * >>>>>>>>>> I have added a screen shot. First button should be a CSV icon. [https://timesheet.sykesit.co.uk/pictures/csv.jpg](https://timesheet.sykesit.co.uk/pictures/csv.jpg) * Thread Starter [gatestar](https://wordpress.org/support/users/gatestar/) * (@gatestar) * [3 years, 7 months ago](https://wordpress.org/support/topic/date-search-does-not-work/#post-16069961) * Try filtering on the week commencing date and doing equals. This is a date field. * Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * (@peterschulznl) * [3 years, 7 months ago](https://wordpress.org/support/topic/date-search-does-not-work/#post-16071617) * Hi [@gatestar](https://wordpress.org/support/users/gatestar/), * The date equals search works, but the request is not submitted. If you enter oct 3 and then press enter on the global search field, it works. The enter key seems not to be recognized by the date field. I will nee to do some further research on this issue and try to fix it asap. * Thanks for the icon image! Your page loads several font awesome file from different versions. I think the problem is that WP Data Access expects version 6 but version 5 is loaded earlier and does not contain this specific icon. Is it possible to completely update to version 6? Or use labels? * To activate panes with server-side processing you need to use the extention manager as explained here: [https://wpdataaccess.com/docs/data-publisher/premium-extensions/](https://wpdataaccess.com/docs/data-publisher/premium-extensions/) Please do not overwrite the dom option in your advanced settings. This option bypasses the extention manager. This works with client-side processing only. With server-side processing panes need to be provided on page load. The extention manager does this for you. There is way to do this manually. * Thanks, Peter * Thread Starter [gatestar](https://wordpress.org/support/users/gatestar/) * (@gatestar) * [3 years, 7 months ago](https://wordpress.org/support/topic/date-search-does-not-work/#post-16071763) * Hi I have also figured out if I turn on the option to search while typing this resolves the issue with the date as like you said the enter key is not being recognised. * I assumed it was font awesome and probably the theme I am using is probably loading this as default. I will load the font awesome v6. * I did used the services premium extensions but nothing appeared so I was looking for an alternative. I will put the extension manager back on so you can see it does not load the pane. * Thanks for your help just ironing out these few issue. * Thread Starter [gatestar](https://wordpress.org/support/users/gatestar/) * (@gatestar) * [3 years, 7 months ago](https://wordpress.org/support/topic/date-search-does-not-work/#post-16072104) * Ok sorted the font awesome and loaded version 6. * One more small issue is as I have a large amount of columns when I use the column button it shows the columns down so I can turn columns on and off, but I cant get to the bottom as it seems to be confined to the length of the page and doesn’t extend it. * I can add picture if you want or go to [https://timesheet.sykesit.co.uk/timesheet-entries/](https://timesheet.sykesit.co.uk/timesheet-entries/) and click the column button. * Thanks * Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * (@peterschulznl) * [3 years, 7 months ago](https://wordpress.org/support/topic/date-search-does-not-work/#post-16074308) * Hi [@gatestar](https://wordpress.org/support/users/gatestar/), * Your table looks great! 👍 * But I see the issue with the column list. You can solve this by adding some css to your page. Please try this: * ``` .dt-button-collection .menu { height: 200px; overflow: auto; } ``` * Thanks, Peter * Thread Starter [gatestar](https://wordpress.org/support/users/gatestar/) * (@gatestar) * [3 years, 7 months ago](https://wordpress.org/support/topic/date-search-does-not-work/#post-16074511) * Hi I still can only see down to Wed and no further is yours different? * Thanks * Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/) * (@peterschulznl) * [3 years, 7 months ago](https://wordpress.org/support/topic/date-search-does-not-work/#post-16075790) * Sorry, menu is not a class but a role… 🙈 * Can you try this: * ``` .dt-button-collection div[role=menu] { height: 200px; overflow: auto; } ``` * Thanks, Peter * Thread Starter [gatestar](https://wordpress.org/support/users/gatestar/) * (@gatestar) * [3 years, 7 months ago](https://wordpress.org/support/topic/date-search-does-not-work/#post-16076185) * That’s great thanks. Viewing 12 replies - 1 through 12 (of 12 total) The topic ‘Date search does not work’ is closed to new replies. * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063) * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/) * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/) * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/) ## Tags * [date search](https://wordpress.org/support/topic-tag/date-search/) * 12 replies * 2 participants * Last reply from: [gatestar](https://wordpress.org/support/users/gatestar/) * Last activity: [3 years, 7 months ago](https://wordpress.org/support/topic/date-search-does-not-work/#post-16076185) * Status: resolved