Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
I purchased wpdatatables. What I would like to do is to calculate a future date based on a base date. For example, if the base date is 1/31, I'd like the table to autocalculate plus 1 month, plus, 2 months etc. up to plus 6 monhts. I'd also like the table to autocalculate base date plus 6 months minus 14 days.
Base date will be in column 1. Plus 1 would be in the second column. etc.
Can the table created in wpdatatable do the above? If so, how?
I purchased report builder. I want the report builder to read the columns in the above table with dates and fill out a form so that the user can download the form in word.
Is this possible?
1. It appears that I can add html code into a cell of a table. Can html be used to do the date calculations?
2. Can I insert java into the cell?
3. here is another possible solution. I create a table of all dates (see attached). it would go out for 20 years of data which is 7300 rows of data. The table (i.e., "above table" mentioned below) which the report builder reads to fill in the variables to build the report would look up the plus 1 month, plus 2 month dates.
Would any of the three above be possible?
Hi James
Thank you for reaching out to us.
Unfortunately, this can't be done out-of-the-box with the plugin. Our Formula columns can only calculate numerical data (integers and floats), but it can't calculate a date difference, nor can this be done with inserting html to a cell.
You can, however, create an SQL query-based table, where you would use DATEDIFF() function to calculate this but I'm afraid we don't provide support for writing custom queries.