Apricot Results Reporting--Formula Calculating date in Future

2 replies
33 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.

Jennifer TravisAnswer

Explorer

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

Jennifer TravisAuthorAnswer

Explorer

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

Rebekah Eslao

Community Manager

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

Sign up

Login with your EveryAction username and password

Login to Bonterra Central

Login with your EveryAction username and password