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
------------------------------
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
------------------------------