Here is the Select im using
I see where your going with this but it will not work. this is comparing the Date in the field unit_paid_date to the current Date with the Day being a variable which is the actual DAY each month its due
im lost but then again ive been trying to learn how to do this for a while now
it should be simple
if the user pays his bill ahead of the due date it leaves him alone
if the users bill was paid say LAST month on the 2nd then it will be marked as late and the record shown
I had at one time it worked all execept say if the user paid his bill Ahead of time it still marked it as a late payment .. and i didnt fully comprehend why so i removed that code and now I dont remember what it was lol..
i hope someone understands my end goal here and can help me out
Thanks