Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding 1 year to a date
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00430291
Message ID:
00430703
Views:
14
>>>I need to add 1 or more year to the start date in a lease application. I use dStartdate + 365 but it does not work for leap years. I coul do something like YEAR(dStartdate) MOD 4 but I was wandering if there was not a simpler method.
>>
>>If someone doesn't have VFP 6, you could do:
>>
>>?date(year(date()) + 1, month(date()), day(date()))
>
>GOMONTH() has been around since FPD 2.5 at least. DATE() with numeric parameters didn't appear until VFP 6.0.

And GOMONTH() still does not work correctly. ;(
Try following lines:

SET STRICTDATE TO 0
tt = {01/01/0003}
? tt && shows correct date - 01/01/0003
? gomonth(tt,12) && shows empty date - \ \

GOMONTH() have such behaviour up to {01/01/1752}
How do you like this bug? ;)
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform