2 Replies Latest reply: Mar 1, 2017 8:13 AM by Maria Harmening RSS

    syntax in load for if statements

    Maria Harmening

      so, I want to calculate some flag values..  basically, I want to do something like this..

       

      if((personName = 1) and (todaysDate >= fieldStartDate) and (todaysDate <= fieldEndDate), 1, 0), as IsThereaRealPersonHereStatus

       

      can I have this complex if statement in the data load script?

       

      Thanks,

      Maria