RE: Error Message when using Date Functions

• umas

  Ten Centuries

  Points: 1219

  More actions

  September 1, 2011 at 9:34 am

  #243131

  Hi,

  Could anybody please help me fix the error message? DtTemp is a smalldatetime variable.

  case

  when (( Datepart(month,dtTemp) > 8 ) or ((Datepart(month,dtTemp) = 8)

  and (DATEPART(WEEK,DAY(dtTemp))))) then

  'Sep-' + cast(right(datepart(yy,dtTemp),2) as varchar(30)) + ' to ' + 'Aug-' + right(datepart(yy,dtTemp)+1,2)

  else

  'Sep-' + cast(right(datepart(yy,dtTemp)-1,2) as varchar(30)) + ' to ' + 'Aug-' + right(datepart(yy,dtTemp),2)

  end

  I am getting the error message "An expression of non-boolean type specified in a context where a condition is expected, near ')' "

  Thank you.

• davidandrews13

  SSCertifiable

  Points: 6836

  More actions

  September 1, 2011 at 9:54 am

  #1376044

  case

  when (( Datepart(month,dtTemp) > 8 ) or ((Datepart(month,dtTemp) = 8)

  and (DATEPART(WEEK,DAY(dtTemp))) = 1 )) then

  'Sep-' + cast(right(datepart(yy,dtTemp),2) as varchar(30)) + ' to ' + 'Aug-' + right(datepart(yy,dtTemp)+1,2)

  else

  'Sep-' + cast(right(datepart(yy,dtTemp)-1,2) as varchar(30)) + ' to ' + 'Aug-' + right(datepart(yy,dtTemp),2)

  end

  you need to have something like what ive put in bold

• umas

  Ten Centuries

  Points: 1219

  More actions

  September 1, 2011 at 9:59 am

  #1376046

  Thanks a lot! It fixed the error.