Mark,

I don't think there's any such animal in VFP. You could use automation to call Excel from VFP, or you could write your own UDF in VFP. The Excel help file explains how this function works, and it looks like it would be simple enough to use VFP's DAY(), MONTH(), and YEAR() functions to adjust the two dates as needed and then return Date2 minus Date1.

-Rick

>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,