Skip to main content
Question

Date Formula Assist

  • January 16, 2019
  • 0 replies
  • 19 views

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?

thanks!
Eric
This topic has been closed for replies.

Forum|alt.badge.img+12
  • Registered
  • January 17, 2019
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.