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

    Null date should be considered as Inefficient

    Siva raja



      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