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!

MONTH operator

Posted by: Margaret

Date: November 09, 2007 10:53AM

I want to extract the month from a date field but when using the MONTH operator I find that any fields with 01 as the day element are calculated as the previous month, ie 01/04/2007 should say 4 but says 3. Any advice on where I'm going wrong?

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.