Date Formula Assist
Hello - I am trying to create a date formula that sends a reminder email when 1465 days after the date in an existing field AND matches one more field value. Can someone show me an example? ...
Forum Discussion
Build a Formula Date Field
If( Today() = ( ToDate([Date Created]) + Days(1465) ) and [Other Field] = xxx, Today(), null)
(where xx is your true-outcome)
Then build your reminder to trigger 0 days before your Formula-Date calculation.
If( Today() = ( ToDate([Date Created]) + Days(1465) ) and [Other Field] = xxx, Today(), null)
(where xx is your true-outcome)
Then build your reminder to trigger 0 days before your Formula-Date calculation.
:) nice work-a-round on that artificial 999 day limit.