SET rs = createobject("ADODB.Recordset")
SET objCDO = Server.CreateObject("CDONTS.NewMail")
SQL = "SELECT Project.record_id as RecordID, Project.original_date as FirstDate, Project.last_contact_date as LastDate, Contact.email_address as EmailAddress FROM Project INNER JOIN Contact ON Project.record_id=Contact.record_id WHERE Project.original_date is not null AND Project.last_contact_date is not null AND Contact.email_address is not null"
ok- here is the question/problem. I need to check two dates against one another. the project.last_contact_date vs the current date. If the datediff = 30 days then it sends them an email. I got the emailer right. And I know my connection string is good.
I cant seem to get the twi dates to read one another and then to implement them in to a loop statement.
This isnt a small company so this database is over 100 tables and approx 6000 records per each table, with more addign everyday.