Phorum: speed & power.

Add-ons for Sage ACT! CRM

ACT! addons by : Abacus Calculated Fields, PicturePlus, Quick Navigation List, Employment History, Quick Search, Presentation for ACT!

calculate 1st of the month after certain date

Posted by: Patti Hoff

Date: May 11, 2009 12:59PM

Can you tell me if it's possible to have Abacus auto calculate the "first day of the month after 30 days" or "first day of the month after 60 days"?

We already have a field that calculates the benefit eligibility date: WHEN [Waiting P]=30 THEN DATEADD(day, 30,[Date Hired])
But some eligibility periods start the "first of the month after" 30 days etc.
Is there a way to have it calculate the first day of the month after the previous formula?

ACT! software CRM addons - best plugins for ACT contact management software ( Act! by Sage software : ACT!2005, ACT!2006, ACT!2007, ACT!2008, Act by Sage Premium for Workgroups ).
Custom addon solutions ( ACT! add ons ) development and CRM (Customer Relationship Management) software training and consulting.