Question

How can I subtract a number of days from the system date?

Answer 1

You can use the java DateUtils to add or subtract days or hours or minutes as needed. Below I'm subtracting 7 days from todays date. You can change the "-7" to whatever number of days you would like to add or subtract.

var DateUtils = org.apache.commons.lang.time.DateUtils;

var oldDate = DateUtils.addDays(qie.deduceDate(qie.getSystemDate()), -7);

var formattedOldDate = qie.formatDate('MM-dd-yyyy', oldDate  );

Answer 2

You can also do this by following the evaluate template approach on this question: https://www.qvera.com/kb/index.php/2468