July 25, 2008 at 12:23 pm
I have a query in SSRS that works with 1 where clause but not another. Can anyone help this newbie?
This works
Where DATEADD(HOUR, -5, e.starttime) between DATEADD(mm, - 3, GETDATE()) and GETDATE ()
This one does not.
Where DATEADD(HOUR, -5, e.starttime) between DATEADD(mm, - 3, @QTR_EndDate()) and @QTR_EndDate)
Error 102: Incorreact yntax near '('
I have tried everything but can't get it to work.
Changinagain
July 25, 2008 at 12:35 pm
Remove the "()" from this, "@QTR_EndDate()", in the second one. That should do it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 25, 2008 at 12:44 pm
AAAAH 😀 Thanks, now it works
Changinagain
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply