Jeanne Boyarsky wrote:Or are you asking how to do a query to get dates less than 3 days away? If so, what database are you using? Have you looked at the date functions for that database?
Hi Jeanne Boyarsky,
yes,I have looked at date functions but i couldn't get the right query to to send mail before 3 days..
Joined: Mar 22, 2005
OK, so the problem has nothing to do with sending emails, and everything to do with writing a SELECT statement. Post the statement you have used so far, and describe which records it -correctly or incorrectly- selects. Also tell us the data types and sample values of the involved attributes.