good day people,I am building a water billing system,i want my penalty column to automatically calculate the amount due.
this is my sample table
date billed due date amount due date paid or number amount paid total balance
09/10/2018 09/25/2018 150.00
1st question),the above says the due date is 9/25/2018 so i want my Penalty column to check if the date paid is less than or equals to due date,then the penalty displays 0.00 but if date paid is greater then due date then it will display (amount due*0.05),,2nd code if the customer did not yet pay or the date paid or column is blank, the penalty column will compare the computer date(today()) if computer date is greater than due date then penalty displays (amount due*0.05) if false,it displays (amount due*0.05).
the 3rd question is how will the second code would stop execute if the date paid is filled with data?
thank you in advance!!
I hope you will anwer my post!