5 Replies Latest reply: Oct 6, 2014 5:45 PM by Colin Pace RSS

    Load Script - if statement with string concatenation

      Hi all,


      I am having problems to have string concatenation in an if statement in a load script SQL statement.



      Select IF(Month(`TxDate`) < 8, 'Season ' + Year(`TxDate`), 'Season ' + (Year(`TxDate`)+1)) AS Season


      Can anyone explain what I am doing wrong?