7 Replies Latest reply: Jun 30, 2016 5:56 PM by Sunny Talwar RSS

    Remove 0 and replace with <NULL> (the DB null, not a string)

    Ali Ahmad

      Hi,

       

      I have a client who sometimes register the wrong amounts and goes in and corrects it to a 0. The issue is that I am using min date and because there is a 0 the date that is connected to that 0 value becomes the lowest date, not the actual real first payment.

       

      Is there any way I can in my script create an IF statement or there is a function to turn something into a NULL so that it get registered as a "nothing"?

       

      Thanks.