WHEN DATEDIFF(MONTH, MIN(mclp.[Starting Date]), MAX(mclp.[Finishing Date])) = 0 THEN CAST(DATEDIFF(DAY, MIN(mclp.[Starting Date]), MAX(mclp.[Finishing Date])) AS FLOAT) ...