Date Formula Assist

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
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
Photo of Eric Schiowitz

Eric Schiowitz

  • 110 Points 100 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of QuickBasePros (Laura Thacker)

QuickBasePros (Laura Thacker), Champion

  • 6,396 Points 5k badge 2x thumb
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.

:) nice work-a-round on that artificial 999 day limit.