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!
Are you sure you want to report this post?

MONTH operator

Posted by: Margaret

Date: 11/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?

You may optionally give an explanation for why this post was reported, which will be sent to the moderators along with the report. This can help the moderator to understand why you reported the post.

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.