Post reply

Case Statement - Prob with greater than DateDiff

  • November 24, 2003 at 2:04 pm

    #83568

    I keep getting an error on the '>' part of this statement. It's driving me nuts!!

    select date_effect,

    case DateDiff(mm, License.date_effect, getdate())

    WHEN DateDiff(mm, License.date_effect, getdate()) > 4 then (License.basefee * 0.05)* (3)+ (License.basefee * 0.1))

    when 1 THEN License.basefee * 0.1

    ELSE (

    (License.basefee * 0.05)* (DateDiff(mm, License.date_effect, getdate())) + (License.basefee * 0.1)) end ,

    from License

    where

    License.STATUS = 'P'

    Any ideas?

  • November 24, 2003 at 2:30 pm

    #483452

    How about try it this way

    select date_effect,

    case WHEN DateDiff(mm, License.date_effect, getdate()) > 4 then (License.basefee * 0.05)* (3)+ (License.basefee * 0.1))

    when 1 THEN License.basefee * 0.1

    ELSE (

    (License.basefee * 0.05)* (DateDiff(mm, License.date_effect, getdate())) + (License.basefee * 0.1)) end ,

    from License

    where License.STATUS = 'P'

    mom

  • November 24, 2003 at 3:13 pm

    #483458

    You're awesome! Thank you!!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply