For the calculation, try =
Date ( Month ( RenewalDate ) - 1 ; Day ( RenewalDate ) ; Year ( RenewalDate ) )
The reminder thing needs more thought: when exactly should it pop-up? "One month before" lasts for 24 hours - and what if it's a weekend and no one is there?
It should pop-up a month before the renewal date. No prob if there is no one there. If it pops up for 24 hrs will be great. Im always here anyway taking a look at it.
For the month, whats the calculation? Is that the one you sent? What about the days that hjave 30 days and 31? and even 28? Thats my main concern.
The calculation returns a date that is the same number of days from the beginning of month as RenewalDate, one month earlier. For example, if RenewalDate is March 31, 2010 the result will be March 3, 2010 (the" 31st day" of February).
If it pops up for 24 hrs will be great.
I am afraid that makes no sense to me. If it pops up for 24 hours, you won't be able to do anything else. I would suggest you set up a startup script that finds the records due for renewal in the upcoming month.
Ok thats sounds good, but the problem is how do i do that? Im new at this FM thing :(