My question is in two parts:
1. How to do date based calculations in mql without manually typing the date?
I tried using MQL with something like "SELECT number, name WHERE 'actual finish' > (TODAY-7)", but this does not work. I then had to write my own custom macro to do the date calculations, and then generate an html table. This is not ideal as there is already a table macro...hence my second question.
2. How to call table, pie-chart or other built in macros from my own custom macros?