Can I setup a reminder email to remind me on the date, instead of x days before or after?
I have a reminder email notification setup, based on the date in a field called "Remind Me On." This is a date field where the user can specify a date in which he or she wants to be reminded of the task. We chose this path rather than standardizing reminders to be sent X days prior to the due date. This way, if someone wants to be reminded a week before or a day before, they can customize their remind date.
In the reminder email template, I have the option to select to be reminded X days before the "Remind Me On" date, or X days after. I attempted to insert a 0 value in that field, and selected "before," hoping that I would get a reminder on the date specified in the field. I did not.
The only other solution I can think of is to create a formula field that takes the Remind Me On date and adds 1 day. Then setup the reminder email to send 1 day before that formula date - which would end up being my Remind Me On date.
Are there any better solutions?
Thank you
Sherri