Skip to main content

Need help on Date plus 20 days

  • November 22, 2019
  • 2 replies
  • 15 views

Hi, I need for CRM to create a formula where it is 20 days after the the last day I add a contact with that person. How to do that?
Thanks!

2 replies

Justin_Barrett
Forum|alt.badge.img+21

Welcome to the community, @Paulo_Calisto! :grinning_face_with_big_eyes: The DATEADD() function will do what you want. Let’s say you have a date field named {Last Contact}. Your formula for something like a {Next Contact} field would be:

DATEADD({Last Contact}, 20, "days")

More details here:


  • Author
  • New Participant
  • November 26, 2019

Welcome to the community, @Paulo_Calisto! :grinning_face_with_big_eyes: The DATEADD() function will do what you want. Let’s say you have a date field named {Last Contact}. Your formula for something like a {Next Contact} field would be:

DATEADD({Last Contact}, 20, "days")

More details here:


Thanks a lot @Justin_Barrett !