Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Month Calculations
Message
From
20/04/2001 19:10:44
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Month Calculations
Miscellaneous
Thread ID:
00498208
Message ID:
00498208
Views:
58
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
Next
Reply
Map
View

Click here to load this message in the networking platform