View Single Post
  #1 (permalink)  
Old August 29th, 2007, 08:11 AM
melkin melkin is offline
Authorized User
Points: 483, Level: 7
Points: 483, Level: 7 Points: 483, Level: 7 Points: 483, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2007
Location: Edgewood, NY, USA.
Posts: 92
Thanks: 0
Thanked 0 Times in 0 Posts
Default Need to query dates after 90 days old

Hi all.
I have a field called "lastlogin". It creates a current date automatically when my users login.

I need to create a query that my IT guy can run to check all the users in the database at call up all the dates that are 90 days old and 120 days old.

I then need all those matching email addresses to get sent an asp cdont mailing to tell them that their account has not been active for 90 days.

I have and use the CDONT mailer, which works perfectly.

What would my query be? Canrt figure it out.

Then, i assume I need an "if" statement that says "if date >90 then" and calls the mailer code, if date =>120 then mail this info and so on. right?

Reply With Quote