Post reply

Derived Column Expression Help

  • February 6, 2013 at 8:26 am

    #151199

    Hello,

    I need some help converting this CASE statement to a valid expression in SSIS.

    Thanks

    CASE WHEN OpenAmountDomestic = 0 THEN 0 ELSE DATEDIFF(day,DueDate,GETDATE()) END AS [OPENDAYS]

  • February 6, 2013 at 8:44 am

    #1584986

    Try

    OpenAmountDomestic = 0 ? 0 : DATEDIFF( "d", DueDate , GETDATE() )

    I can't test it for you but it should be along those lines

    Mack

  • February 6, 2013 at 9:14 am

    #1585006

    Thanks, that was perfect

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

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