We would like to change the background color of individual Rows within a Power Table based on some system.date calculations.
Take a look below at where we are currently at. no error msg but the row doesn’t turn red.
I was thinking of adding the timeFrame(int) to the PMdate and comparing it today’s date(using isAfter) to determine if this task is overdue or not. When Today’s date is after redDate then change backround of that row to Red color.
pmTimeFrame = 30(INT)
PMdate = 2019-01-23
Today = 2020-01-21
redDate = 2019-01-23 + 30