AnsweredAssumed Answered

Check backpay dates

Question asked by nolak37 on Feb 1, 2010
Latest reply on Feb 1, 2010 by nolak37

Title

Check backpay dates

Post

Hi,

 

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

 

Josh

Outcomes