wpDataTables doesn't have an option to calculate date differences. You'd need to use the datediff() function of MySQL in order to get the data you need in a new column.
This requires some MySQL knowledge, and is not included in the provided support for the plugin, but I can provide you with some pointers:
How to calculate dates? Ex. Subtract one date from another to give the difference in days?
Hello John.
wpDataTables doesn't have an option to calculate date differences. You'd need to use the datediff() function of MySQL in order to get the data you need in a new column.
This requires some MySQL knowledge, and is not included in the provided support for the plugin, but I can provide you with some pointers:
https://stackoverflow.com/questions/2490173/how-to-get-the-number-of-days-of-difference-between-two-dates-on-mysql
https://stackoverflow.com/questions/4759248/difference-between-two-dates-in-mysql
I hope that helps.
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
Yes, datediff( ) is what I will use.
Thanks again!
You're welcome John.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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