date and email

[Anon]

well i need to send a automated email based on the date in the database record.

thus which functions to use. i need to send a email 7 days in advance of the date field in the table record. i am using the function now() for the timestamp when inserting the date in the database base on a user entry form

thanks in advance

[Anon]

Please be a little more clear, right now... The way you explained it. An e-mail would never be sent. (the date will never be 7 days before today, if you know what I mean)

Clear this up, let me know!

-Travis

[Anon]

hi travis.

i got a form where users fill up. i insert the date in the database with the function now(). where the users fill up a date in the future.

i need to write a function where the user is reminded 7 days in advance from the future date he has filled up in the form. it is a reminder. i am a bit confused as to which date functions to used.

thanks
kalyan