Need to create a date based reminder
Hello, I have a start date field in my Position table. I need to create a reminder that sends an email to the email address in the Supervisor Email Address field 30 days before the start date in t...
Forum Discussion
You could try something like this:
var number serviceYears = If(Year(Today()) > Year([Start Date]), Year(Today()) - Year([Start Date]), 0);
If($serviceYears > 0, AdjustYear([Start Date], $serviceYears) - Days(30), null)
------------------------------
Paul Peterson
------------------------------
var number serviceYears = If(Year(Today()) > Year([Start Date]), Year(Today()) - Year([Start Date]), 0);
If($serviceYears > 0, AdjustYear([Start Date], $serviceYears) - Days(30), null)
------------------------------
Paul Peterson
------------------------------
- Hi Paul,
Thanks for responding! Would that be a separate field that I am creating and that is what I would use? or is that something I would embed in either the notification or reminder?
------------------------------
Andrea Johannes
------------------------------- Yes, it would need to be a new field. And looking at the Reminder setup options, you could omit the "- Days(30)". Suppose you name the new field Anniversary Date, when you create the reminder set it to Remind When 30 days Before the date in the field Anniversary Date.
------------------------------
Paul Peterson
------------------------------- Thank you Paul! I was able to create a field using that formula and it's working great. Now I need to be able to send an email to the email address in the superivsor email field. The reminder won't let me do that - and the notification requires something to happen to the position record in order to fire. Is there another way to generate that email to the email address in the supervisor field other than using reminders or notifications?
------------------------------
Andrea Johannes
------------------------------
