topic Re: Last 7 days query, error near '<' in DAX Commands and Tips

Last 7 days query, error near '<'

Anonymous — Mon, 14 Jun 2021 17:42:24 GMT

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.

Re: Last 7 days query, error near '<'

amitchandak — Mon, 14 Jun 2021 17:46:36 GMT

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())))

Re: Last 7 days query, error near '<'

Anonymous — Mon, 14 Jun 2021 18:06:20 GMT

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).