Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Substract month from month
Message
From
25/07/2005 01:32:55
 
 
To
25/07/2005 01:08:16
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows '98
Network:
Windows 98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01035596
Message ID:
01035600
Views:
14
Hi Robert.

One way to do it is as follows -
lnMonths = Val(Substr(TextBox.Value, At("-", TextBox.Value)+1)) * 12 + Val(TextBox.Value) - 1
lnMonths = lnMonths - 3
TextBox.Value = Padl(Int(lnMonths) % 12 + 1, 2, "0") +"-"+ Str(Int(lnMonths / 12), 4)

Ian Simcock.


>Dear Sir,
>
>I have a character type textbox="02-2005" && February 2005
>I want to substract 3 months from it.
>
>Please elp
Previous
Reply
Map
View

Click here to load this message in the networking platform