learning-history-sql.txt

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))