>Ok, here's the story.
>
>I have this function which adds one year to today's date for those not having a PUTM which have paid since midnight. This morning, I had several to approve. However, it took me a few minutes to understand why the date was not showing while I was approving those transactions. It works for those having taken a PUTM for one month as it brought them to March 29, 2000. However, it didn't work for those having taken a PUTM for a year which would have brought them to Feb 29, 2001. Then, I realized there won't be such a date for the next 3 years. So, if the date is not valid, it's a blank date which was put in the field, as per the current coding.
>
>Oh well, that's just one of those situations. lol
>
>BTW, anyone has a function to take care of that? I don't want to reinvent the wheel. :)

How about:

dRenewDate = GOMONTH(dExpireDate,12)