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

    Date Expression

    Raman Singh

      Hi,

       

      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?


      Thanks