Date Formula Assist

  • 0
  • 1
  • Question
  • Updated 4 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?

Photo of Eric Schiowitz

Eric Schiowitz

  • 110 Points 100 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 4,208 Points 4k 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

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