show last week with sql-satement

[230173]

Hi,

Can somebody help me with a sql-statement that i need to show the last week of a tabel with a date field.

i've already tried:
select BLAH from Blah where DateField between
#DateAdd("d",-6,Date)# and #Date#

and also

...where datediff(&quot;d&quot;,datefield,now()) <= 7

 

[GaryC123]

How about something like
startdate=date-7
enddate=date

select BLAH from Blah where DateField between
#startdate# and #enddate# Saturday 12.00

20.00

3.00am

Sunday [img http