Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to set a Background Color expression by date. I want it to show green if within a year of the LAST_INSPECTION_DATE or Red if greater than a year of the LAST_INSPECTION_DATE.
I have
IF(Year(Aggr(max(LAST_INSPECTION_DATE),TRAILER)) > AddYears(Aggr(max(LAST_INSPECTION_DATE),TRAILER),1), LightRed(),Green())
And I get this all green