Forum Discussion

EricSchiowitz's avatar
EricSchiowitz
Qrew Member
7 years ago

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?

thanks!
Eric
Formulas and functions
  • LauraThacker's avatar
    LauraThacker
    Qrew Captain
    7 years ago
    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.