5 Replies Latest reply: Jan 19, 2016 11:47 PM by Nishit Oza RSS

    Error with multiple if statements

    sneha jha

      Hi ,

       

      I am trying to enable if condition to create a calculated field called Results.DateShip.

       

      However I get strange result for Results.DateShip = 570710725 and 570710731

       

      if(Final.DateRequest<=today()and ECL.CutoffTimeCheck='good',

        EO1.DateShip,

        Date(today(),'YYYYMMDD')),

       

      if(Final.DateRequest<=today()and ECL.CutoffTimeCheck='late',

        EO1.DateShip,

        Date(today()+1,'YYYYMMDD')),

       

      if(Final.DateRequest>today(),

        EO1.DateShip,

        Date(Final.DateRequest,'YYYYMMDD')) as Results.DateShip

       

      Can anyone suggest where I am going wrong ?

       

      Thanks for any help.