USE IF IN SET (SCRIPT)

Thu, 14 Feb 2013 20:55:24 GMT

Hi,

Can we use a condition in SET in the script:

if( "CONDITION",SET DateFormat ='M/D/YYYY' , SET DateFormat ='MM-DD-YYYY' )

Thanks,

Nima

Re: USE IF IN SET (SCRIPT)

CELAMBARASAN — Thu, 14 Feb 2013 21:04:49 GMT

May be you should use this

LET DateFormat = if( "CONDITION", 'M/D/YYYY' , 'MM-DD-YYYY' );

If (Condition) Then

SET DateFormat ='M/D/YYYY';

Else

SET DateFormat ='MM-DD-YYYY';

End If;

Hope It Helps

Celambarasan