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

0 votes
asked Sep 21, 2018 by michael-h-5027 (14,030 points)

2 Answers

+1 vote

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  );

answered Sep 21, 2018 by michael-h-5027 (14,030 points)
edited Dec 16, 2021 by jon-t-7005
0 votes
You can also do this by following the evaluate template approach on this question:
answered Jan 24 by ben-s-7515 (11,910 points)