I'd like to have the background color of a date field have a different color
f.e if a target date (real ISO date in the file) is 5 days overdue : green color
if it is 10 days overdue : red color...
so i have to compare with the current date..
don't know how i can set this in the NAB (grid) conditional formatting for colors;...
tried with (new Date()), but this is considered as an alfa string...
f.e if a target date (real ISO date in the file) is 5 days overdue : green color
if it is 10 days overdue : red color...
so i have to compare with the current date..
don't know how i can set this in the NAB (grid) conditional formatting for colors;...
tried with (new Date()), but this is considered as an alfa string...
Comment