Comments Nurul Umairah started the conversationDecember 9, 2020 at 2:11amHi, I have a date range filter [ from <starting date> to <end date>] and I am looking into calculating the number of days when my visitors filter specific periods from the filter function. Is there any way I can do this? 2,572Aleksandar repliedDecember 10, 2020 at 10:49amHello NurulThank you for your purchase.You cannot do this with the built-in features of the plugin.The only way you could do it is by creating an SQL query based table, and adding a new DATEDIFF column.We do not provide support for custom SQL queries, but please check stack overflow, and see how you can use the DATEDIFF function to do this.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 Sign in to reply ...
Hi, I have a date range filter [ from <starting date> to <end date>] and I am looking into calculating the number of days when my visitors filter specific periods from the filter function. Is there any way I can do this?
Hello Nurul
Thank you for your purchase.
You cannot do this with the built-in features of the plugin.
The only way you could do it is by creating an SQL query based table, and adding a new DATEDIFF column.
We do not provide support for custom SQL queries, but please check stack overflow, and see how you can use the DATEDIFF function to do this.
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