I'm querying data from TCS (Aspect) workforce management software, and want to get data for the last week... rather than editing the SQL with VBA, I'd rather just use >(DATE - 8) or SYSDATE, or CURRENT_DATE, or something. Every magic "date" incantation I have tried fails. Any thoughts?