USE IF IN SET (SCRIPT)

[#1]

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

[CELAMBARASAN]

May be you should use this

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

Or

If (Condition) Then

SET DateFormat ='M/D/YYYY';

Else

SET DateFormat ='MM-DD-YYYY';

End If;

Hope It Helps

Celambarasan