Post reply

Multiple CASE WHEN

  • January 8, 2008 at 12:27 am

    #95778

    Kindly assist me in formating the query below

    IIf(ISNULL(PlannedDR5Duration)=0,[ActualDR5Date],

    IIf(ISNULL(PlannedRFSDuration)=0,[ActualRFSDate],

    IIf(ISNULL(PlannedRFADuration)=0,[ActualRFADate],

    IIf(ISNULL(PlanneDR4Duration)=0,[ActualDR4Date],

    IIf(ISNULL(PlannedDR2Duration)=0,[ActualDR2Date]))))) AS ProjectCompletionDate,

  • January 8, 2008 at 12:37 am

    #765598

    Hi,

    I hope this is what you are looking for:

    CASE

    WHEN PlannedDR5Duration = 0 THEN [ActualDR5Date]

    WHEN PlannedRFSDuration = 0 THEN [ActualRFSDate]

    WHEN PlannedRFADuration = 0 THEN [ActualRFADate]

    WHEN PlanneDR4Duration = 0 THEN [ActualDR4Date]

    WHEN PlannedDR2Duration = 0 THEN [ActualDR2Date]

    END AS ProjectCompletionDate

    Regards,

    Oana.

  • January 8, 2008 at 12:52 am

    #765599

    Hi Thanks a loads its working

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

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