Last 7 days query, error near '<'

[Anonymous]

 I have a query I am running it selects data from 2 tables. I am trying to get get both tables to uese the same date range. The query below was modified to try to get both tables to return the last 7 days worth of data. The blue text is what I added.

WHERE (d.TimeDown >= DATEADD(day, - 7, GETDATE(), (Date >= DATEADD(day, -7, GETDATE()))"]),  I get a syntax error near ">" which started when I added the second date statement. Can this be resolved, or am I writing this incorrectly? So far, my original table will pull the last 7 days as requested, but the second table delivers everything since 2005.

[Anonymous]

No, I am looking for the past 7 days. Today, I would be looking for June 7th thru June13th from both tables One uses the the 'TimeDown' field as the date, the other currently uses 'Date' Note: I could use TimeOpen in table 2, which would give me two date/time fields (if that is easier).

[amitchandak]

@Anonymous , are you writing a SQL in advance option

try like

WHERE (d.TimeDown >= DATEADD(day, - 7, GETDATE()) and (d.TimeDown <= DATEADD(day, 0, GETDATE())))