>We need to determine exactly how many months difference there is between 2 dates in VFP
>Example:
>01/01/2001 - 03/01/2001 = 3 months
>
>We are currently trying the following:
>x=date1 (01/01/2001)
>y=date2 (03/01/2001)
>z=y - x
>b=z/365*12
>c=b +1
>
>result=int(c)
>
>The problem we are running into is short months
>
>
>Larry
Larry,
See Some useful date functions July 12, 1997 12:20 FAQ #7661 by Paul Vlad Tatavu
If it's not broken, fix it until it is.
My Blog