5 Replies Latest reply: Jul 25, 2018 7:34 AM by Raman Singh RSS

    Date Expression

    Raman Singh



      I am trying to exclude rows not required from my dataset but my expression does not seem to be working.


      In data load editor I have created the below column:


      IF(DATE(Exp_PODDate) = DATE(Today()),1,0) AS Exp_PODDateTODAY


      I have then created the below expression using the above column:


      =IF(Exp_PODDateTODAY = 1,Exp_PODDateTODAY)

      Could someone please help with what I have done wrong?