Discussions

Expand all | Collapse all

Date Formula Assist

  • 1.  Date Formula Assist

    Posted 01-16-2019 18:33
    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


  • 2.  RE: Date Formula Assist

    Silver
    Contributor
    Posted 01-17-2019 17:11
    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.



  • 3.  RE: Date Formula Assist

    Posted 01-17-2019 17:15
    :) nice work-a-round on that artificial 999 day limit.