Customize Formula

[mc3137]

Hello:

I need some direction. I thought this would be simple but after giving it the old college try for more than 90 minutes...

Anyway, I have two date fields I want to use to calculate the third date fields. I manage contracts and I need to create a field that will display the date to start contract renewal process. My two fields, BEGIN and END, are set as dates, and field cannot be empty. RENEWAL REMINDER is supposed to be a calculated field. Result should be 3 months before end date. On Validation tab of RenewalReminder, I set it to not empty, check calculation, and click specified, using this formula:

renewalreminder = month(begins) + 7

hoping that it would display the Month of begin field, add 7 calendar months, and display the result.

In the field I get a ? mark. What am I doing wrong?

[comment]

What am I doing wrong?

Just about everything, I am afraid. :

Make RenewalReminder a Calculation field. Set the result type to Date and use the following formula =

Date ( Month ( END ) - 3 ; Day ( END ) ; Year ( END ) )

[mc3137]

Thanks. Trying it now.

[Vaughan]

I thought this would be simple but after giving it the old college try for more than 90 minutes...

Did anybody else find this rather amusing? :

[Rick Whitelaw]

After all tis time, I guess not!

RW

[Ron Cates]

I did