I have had a hard time for some time. I have searched, but I have not found anything that would help me.
I need to do a calculation on a query, it is the following. I need to get the day the record was entered in the bank and then do an operation with the current date, I have to subtract the current date by the date that was entered in the bank, if the subtraction value is greater than 3, I will know that this record is late. So I need to do this to keep track of my table, and count how many are behind schedule. I know I should use COUNT(*)
, DATADIFF
, INTERVAL
, and so on but I could not. It is possible ? How would it be? Thank you.