If I understood you correctly - you have a date column, and you want another column where you'd be able to calculate how many days past from the first entry to now?
If that is true, I'm sorry to disappoint you but it can't be done with the plugin's built in features. The formula columns that do calculations like this only deal with integers and floats.
So to do this, you would need to convert the date in PHPMyAdmin and return that as integers, so it could be calculated. Then, you can calculate how many days passed between those two dates.
In short - you'd have to create the SQL table to perform all necessary calculations, and our plugin would just display it.
Please note, though, that creating custom queries for you doesn't fall under included support of the plugin, but it is available as paid service.
I want to make a table that would count how meni day have past from the date from a different cell.
Best regards Arturas.
Hello Arturas.
If I understood you correctly - you have a date column, and you want another column where you'd be able to calculate how many days past from the first entry to now?
If that is true, I'm sorry to disappoint you but it can't be done with the plugin's built in features. The formula columns that do calculations like this only deal with integers and floats.
So to do this, you would need to convert the date in PHPMyAdmin and return that as integers, so it could be calculated. Then, you can calculate how many days passed between those two dates.
In short - you'd have to create the SQL table to perform all necessary calculations, and our plugin would just display it.
Please note, though, that creating custom queries for you doesn't fall under included support of the plugin, but it is available as paid service.
Best regards.
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
Hello Aleksandar.
Thank you for information.
Best regards Arturas.
You're welcome Arturas.
If you have any further questions or issues, please feel free to reach out to us.
Best regards.
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