Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding whole years to a date (code/function request)
Message
 
To
29/01/2003 11:11:57
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00746716
Message ID:
00746721
Views:
19
What about:
lddate=date()
?datetime(year(lddate)-3,month(lddate), day(lddate))

The only problem I see here for february 29 of the leap year (it will return empty date for initial lddate=02/29/2000).

>I want to know if someone has a neet function to add/substract whole years to a date or datetime. It needs to take into account leap years and check that it doesn't produce illegal dates (ex: add 5 years to Feb 29 2004).
>
>I know I could code the long way - but is there some FOXPRO function (foxpro has a function for everything) or ellegant snippet that I can use.
>
>Thanks from frigid Ottawa Canada
Previous
Reply
Map
View

Click here to load this message in the networking platform