trying all sorts of things here but no matter how I edit the SQL, I get zero results -- any help would be immensely appreciated!
version 1: trunc(e.compl_dte) >= Sysdate-7
version 2: e.compl_dte >= Sysdate-7
version 3: compl_dte between (trunc(Sysdate-7)) and (trunc(Sysdate))