I have a saved search to show a list of quotes and their statuses. I need to figure out how to highlight the row if the statuses were set x amount of days ago, so if say the status was changed to 'Quote Sent' a day or more ago, it will be highlighted. I have something like this but not working, any suggestions? CASE WHEN {entitystatus} = 'Quote In Process' AND ({systemnotes.field} = 'Status' AND {systemnotes.newvalue} = 'Quote In Process' AND {today} >= {systemnotes.date}+1) then 1 else 0 end

You prob need to use a built in db function on the date to be able to add the +1 to it.

I don't know that I'd do a system notes approach on this... I'd probably want to throw a workflow that looked at old record vs new, and that dropped a date field that I could then use on my saved search