Check backpay dates
I need a script that will check if a payment is past due and im not very familiar working with dates.
I have a field in my table named payment status, this is automatically set to "Pending" when the record is created.
The script should check all records in the DB, on the ones pending check the date created and compare to CurrentDate.
if it is 30 days past i will set it to send an email using SMTP to the Billing Department. (i already know how to do this)
if anyone can help me with the part of thee script that check the dates I would greatly appreciate it, also if you could break it down so i can see what each part does or means im sure it would help me learn for future refrence.
Thanks in advance