ActPresentation.com HOME FAQ FORUM info@ActPresentation.com
Phorum: speed & power.

ActPresentation.com


Add-ons for Sage ACT! CRM

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

How to add number of months to the date ?

Posted by: Austin

Date: July 24, 2007 12:49PM

I am attempting to have a Due Date field calculate by adding the terms (number of months) to the orgin date and it does not seem to like whay I am asking it to do.

Re: How to add number of months to the date ?

Posted by: Admin

Date: July 24, 2007 12:54PM

The following formula adds 10 months to [Origin Date] field.

DATEADD( month, 10, [Origin Date] ) -- add 10 months to 'Origin Date' field

Re: How to add number of months to the date ?

Posted by: Austin

Date: July 25, 2007 12:16PM

Great that worlked! Now how do I replacate or copy the same formula to another field?

Re: How to add number of months to the date ?

Posted by: Admin

Date: July 25, 2007 12:23PM

Just use clipboard. Copy/past operations are supported in formula editor.

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.