Can you help me with a date calculation?

[mlplouff]

Maybe my brain is just throwing static this week, but I'm having trouble with a couple of date fields. I'm hoping this is as easy as breathing for someone here who can help me. Things have been working in v6, but v7 is different enough that I'm having trouble.

I'm keeping track of paid membership in an organization. There are different payment options that end up changing MonthsPaid (it's either 12 or 15). I want to add MonthsPaid to DateLastRenew and get the new DateNextRenew. All subscriptions expire on the 15th of the month - so if you join (or renew) in January 2005, any day in January, your DateNextRenew would be either 1/15/06 or 4/15/06.

in FM v6, I had defined DateNextRenew as a calculated field:

Date(

(Month(DateLastRenew) + MonthsPaid) ,

(Day(TextToDate("1/15/1999"))),

(Year(DateLastRenew))

)

Can anyone help me rephrase this for v7?

THANKS!

- Maurita

[RalphL]

Date(

Month(DateLastRenew) + MonthsPaid ,

15,

Year(DateLastRenew)

)

Should work in both 6 & 7.

[mlplouff]

THANKS!