Pulling data for current week Sat - Friday:

What would be the best way to show weely timesheet data?  Each ETNumber already has a built in timeslice.  So it's like b.date for that project.

I just need to show the data for the current week back through Saturday.  I'sn't there something built into the date fctn?

Date               Sat     Sun      Mon     Tue      Wed    Thu      Fri
ET Number     b.date  b.date  b.date  b.date  b.date  b.date  b.date  
ET Number     b.date  b.date  b.date  b.date  b.date  b.date  b.date  

I don't understand how you would get 7 different days in a single row.  The "b.date(-7)" part is where I don't get it.

Would it be something like?...
Select
ET_NUMBER,
b.date(-7)
b.date(-6)
b.date(-5)
b.date(-4)
b.date(-3)
b.date(-2)
b.date(-1)
from
xxx
Where
xxx


The first two days would actually come from the last week.

So I need last week's Sat and Sunday.
Then Monday thru Friday.

Thanks in Advance!