OK, I don't know.
Cetin
>hi,
>thank you very much.
>put still i have problem with month 1,2, and month 9
>if i start date as 01/01/2006 or 09/01/2006 or 02/01/2006... it works ,
>
>but if i start with another date as 01/05/2006....etc for this 3 months
>
>wrong compute for the first and end records at the grid
>
>pls.
>
>run it as
>value =900
>month=5
>start date as =01/05/2005 or 02/05/2006 or 09/05/2006
>
>soryy to bother you again.
>
>thanks
>try valu 900 and start with 02/11/2006...
>
>thanks.
>
>>You could do this yourself. Anyway:
>>
>> lnDaysInMonth = Day(Gomonth(m.ldCurrent,1)-Day(Gomonth(m.ldCurrent,1)))
>> Do Case
>> Case m.ix = 0
>> lnAmount = m.lnPayment * ((Day(m.ldTo)-Day(m.ldCurrent))/(m.lnDaysInMonth-1))
>> Case m.ix = .txtMonths.Value
>> lnAmount = m.lnPayment * ((Day(m.ldCurrent)-1)/(m.lnDaysInMonth-1))
>> Otherwise
>> lnAmount = m.lnPayment
>> Endcase
>>
>>Cetin
>>>hi,
>>>
>>>i mean if i start 01/07/2006 or 14/07/2006 and month 1,3,5,7,8,10 and month 12,it works,
>>>
>>>but if i start as 01/06/2006 or month 9,4,11 wrong result at first date and last date at the grid.
>>>
>>>and big deferrent value if i start with month2,
>>>
>>>just try any number ex.. 800.
>>>
>>>thanks.
>>>