Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Month Calculations
Message
From
23/04/2001 18:04:09
Michael Swain
Ely, United Kingdom
 
 
To
20/04/2001 19:10:44
Larry Hurwitz
Inimage.Net
Alpine, Utah, United States
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Re: Month Calculations
Miscellaneous
Thread ID:
00498208
Message ID:
00498780
Views:
28
If you want whole months i.e. 2nd Jan to 1st March = 1 month, then

If T1 is later date and T2 is earlier date

Monthdiff = 12*(year(t1)-year(t2)-1) + month(t1)-month(t2) - iif(day(t1)
Regards

Mike
Regards

Mike
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform