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!!