Change row colour in a column based on due date
Hi All,
I have a requirement to display a row in a column into red after it reach 3 days from the due date. I am currently using PEGA 7.2.1. The method i use is based on this discussion https://collaborate.pega.com/question/date-difference-calculation , so i am using cell inline style with this script:
<pega:when test="com.pegarules.generated.DateTime.DateTimeDifference(.ReportFilter.DueDates,com.pegarules.generated.DateTime.CurrentDateTime(),"D") >= 3 "> color: black; background-color: red;</pega:when >
.ReportFilter.DueDates property type is DateTime. The problem is, the table is displayed but the colour is not changing even the due date is more than 3 days. Is there any solution to achieve that?
Best regards,
Gigih