Date Formula Assist

  • 0
  • 1
  • Question
  • Updated 3 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 3 months ago

  • 0
  • 1
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 3,760 Points 3k 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.

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,036 Points 50k badge 2x thumb
:) nice work-a-round on that artificial 999 day limit.