Query problem in SSRS

• BKW

  Ten Centuries

  Points: 1350

  More actions

  July 25, 2008 at 10:44 am

  #191533

  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.

  :w00t:

  Changinagain

• Michelle Burke

  Right there with Babe

  Points: 743

  More actions

  July 27, 2008 at 5:47 pm

  #848930

  Where DATEADD(HOUR, -5, e.starttime) between DATEADD(mm, - 3, @QTR_EndDate) and @QTR_EndDate)

  should work. You had brackets () after the @QTR_EndDate in the DATEADD. Should fix the problem.