Skip to main content
Jennifer Travis
Jennifer Travis
Explorer
August 5, 2026
Solved

Apricot Results Reporting--Formula Calculating date in Future

  • August 5, 2026
  • 2 replies
  • 13 views

I need to calculate a date 6 months from a date in my data. What formula can I use?

 

I have a report that was submitted and want to know when it has been 6 months, so that I can remind my team to complete another. I am wanting to use ARR and send it out at a regular cadence. 

Best answer by Jennifer Travis

Got it from Bonnie :-) = FormatDate(RelativeDate([Date Object];6;MonthPeriod);"MM/dd/yyyy")

2 replies

Jennifer Travis
Jennifer TravisAuthorAnswer
Explorer
August 5, 2026

Got it from Bonnie :-) = FormatDate(RelativeDate([Date Object];6;MonthPeriod);"MM/dd/yyyy")

    Rebekah Eslao
    Rebekah Eslao
    Community Manager
    August 6, 2026

    Great question! Looks like Bonnie got you sorted with the formula :) If you need any clarification on the formula or run into any issues implementing it, feel free to jump back in. 

    Rebekah at Bonterra
    Terms & ConditionsAccessibility statement