Create variable

building reports webintelligence
2

If your DB is Oracle, then this might help guide you along

select next_day(trunc(sysdate), 'sunday') - 14, next_day(trunc(sysdate), 'saturday') - 7 from dual;

Theres a nice sticky on Relative Date Functions found here which is where I found the above code

mwinchel :us: (BOB member since 2011-12-13)