|
date_arithmetic using a field instead of a set number
In Calibre, I have a custom column that predicts how many days it will take to finish a book based on my wpm and the word count of the book. I would love to have a secondary column that predicts the finish date of the book. The date_arithmetic function is close to what I need, I think, and would look something like this (perhaps?):
program:
date_arithmetic(today(),field('#completiondate')d)
where field('#completiondate') is my column that predicts how many days it would take to finish the novel. However, I don't think date_arithmetic works with a variable field instead of a set number increase. (or if it does, I am unsure where to put the single quotes) Does anyone know a way to accomplish this?
|