>>>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.comICQ #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.