Thanks, I will try this. I was ready to just use OLE to call the function, but I'll try this first.
>There was a problem with the way my original post stated the solution
>>I've done 360 accounting (30/360,ACT/360,etc). You gota count the months, then multiply by 30 (assuming 30/360) and then add the change (days).
>>Here is on method you could use:
>>ldStart={^2000-6-30}
>>ldEnd={^2000-12-31}
>>lncountmths=0
>>lsStart=left(dtos(ldStart),6) && YYYYMM
>>lsEnd=left(dtos(ldEnd),6)
>>lsPointer=lsStart
>
>>do while lsPointer < lsEnd
>
>>if val(right(lsPointer,2))>11
>> lsPointer=str(val(left(lsPointer,4))+1,4)+"01"
>>else
>> lsPointer=left(lsPointer,4)+right(str(val(right(lsPointer,2))+101),2)
>>endif
>>lncountmths=lncountmths+1
>>enddo
>>messagebox(str(lncountmths))
>>Or - you could OLE w/Excel and use the Excel function.
>>
>>
>>
>>>I am working on replacing an Excel spreadsheet to VFP in order to use the data for multiple reporting options. The data needs to be in a dbf format. Currently one of the calculations in the Excel spreadsheet uses the Excel function DAYS360. This returns the number of days between two dates based on a 360 day year (not 365 or 366 in leap years). I have been told this is a common accounting method. I have not found an equivalent VFP function to do this.
>>>
>>>Has anyone else seen this, is there a function in VFP that would return the same result, or has anyone else written a function to match this?
>>>
>>>Thanks,
Mark Johns