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.

      Example:

      SQL

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

       

      Can anyone explain what I am doing wrong?