>>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()))
Try this, Hotshot:
dDate = {2/29/2000}
?DATE(YEAR(dDate) + 1, MONTH(dDate), DAY(DDAte))
:-)
Erik Moore
Clientelligence