7 Replies Latest reply: May 21, 2012 3:32 AM by 2perform RSS

    IF in script in order to  replacing zero values into time

    2perform

      Hi All,

       

      Why is this    expression

       

       

      if( IsNull(OPNTIJD)=0,OPNTIJD,0.33333)

       

      working well as normal expression but not working when i do this in the script

      as below.

       

      LOAD

      OPNDAT,

      OPNTIJD,

      if( IsNull(OPNTIJD)=0,OPNTIJD,0.33333) as ADMDAT

      Resident BEDOCUP;

       

      My goal is to replace zero value´s into 08:00 hour preferable is to do this in the script.

       

      THANKS IN ADVACE!!