Home Forums SQL Server 7,2000 T-SQL Date Range condition in WHERE clause RE: Date Range condition in WHERE clause

  • July 7, 2008 at 1:53 pm

    #839149

    You are converting the dates to string before comparing them, instead of comparing dates. Do it like this:

    where EffDt >= '20080601' and EffDt < '20070101'