I have a table that has users' email addresses, an integer field that is number of days in which to email them a reminder, and a datetime field that is the date the record was added, something like this:
ID Email ReminderInDays DateAdded
1 email@example.com 30 2012-03-15 11:00:39.483
2 firstname.lastname@example.org 120 2012-04-02 08:00:49.217
3 email@example.com 60 2012-04-02 08:02:27.573
I need to be able to run a query and get all the emails that should be sent a reminder, so basically selecting all emails for which the number of "ReminderInDays" has past since "DateAdded"