Configure formula field to calculate Anniversary dates(every 6 months)

  • 22 May 2020
  • 3 replies
  • 337 views

In the below document, I have explained how to calculate the every 6th month anniversary dates and store in a separate field so that we use it to send surveys( whenever you wants to send NPS survey who completed 6 months), use it in rules and reports wherever required. Since I am creating a formula  field in Sfdc and bringing it into Gainsight, this work-around will be applicable only customers on salesforce platform

 

Calculate the anniversary dates(every 6 months)


3 replies

Userlevel 7
Badge +3

Awesome! Thanks for sharing @Jyothsna :clap_tone3:

Userlevel 7
Badge +1

In the below document, I have explained how to calculate the every 6th month anniversary dates and store in a separate field so that we use it to send surveys( whenever you wants to send NPS survey who completed 6 months), use it in rules and reports wherever required. Since I am creating a formula  field in Sfdc and bringing it into Gainsight, this work-around will be applicable only customers on salesforce platform

 

Calculate the anniversary dates(every 6 months)

Thanks for sharing it here!

Userlevel 5
Badge +3

Thanks, @Jyothsna for sharing the detail information, it helps a lot.

Reply