5 Replies Latest reply: Jun 16, 2014 4:25 AM by Staffan Johansson RSS

    Is null handling with 3 dates

    Staffan Johansson

      Hi,

       

      I have a problem: this is my table

      2014-06-16_0814.png

      This should be handled in this way, pseudocode:

      if(isnull(date1),date2,date1) and if( isnull(date1 and date 2),date3) as Finaldate

      I do this in the script, does anyone have a quick solution?