Skip to Content
0
Former Member
May 22, 2009 at 08:18 AM

IP: FOX Month Function

92 Views

Hi experts,

I need to revaluate the amount for a particular period where the user will assign a start and an end date. In back ground the revaluation should happen on the previous month and store on the current month. For example, if the data is like this:

Month: Amount

Mar 08: 100

Apr 08: 105

May 08: 110

Jun 08: 120

Jul 08: 130

Aug 08: 135

and the user wants to change amount for Apr 08 to Jul 08 by 10%, then in background i should calculate 10% increase on Mar 08 to Jun 08.

I am trying to write a fox. Can you please help how to read the first month and last month from a Period Interval variable. and how to use offset in FOX..

Thanks, Rishi