1 Reply Latest reply on Sep 7, 2016 5:53 AM by Luis Amadeo

    Null date should be considered as Inefficient

    Siva raja

      Hi,

       

      I have a date 1 and date 2.

       

      Used datediff ('day', date 1, date 2 ) > 0. If difference > 0 then inefficient else efficient. simple logic and count is calculated.

      But if i have null inside date it is showing 'efficient'. I need that to be grouped in 'inefficient' and count should also be correct.

       

      Please help

       

      Thanks,

      Siva