Calculating Future Dates for next review

[lidoh]

Hi,

I am struggling with a field calculation. I have a field "date of next review" and I want to make it a calculation field, so when ever a person edits a record and the auto input command inputs the " date of modification", It automatically calculates the "Date of next review". Say 2 month from the modification day.

Thanks in advance for all help.

Jaime

[LiveOak]

There is the easy way and the hard way. The easy way is just to define a field (ModDate) set to auto enter the Modification data and base another field on it.

NextReview (calculation, date) = ModDate + 60

This gives you sixty days, which you may or may not consider two months. If you want to add two months, the situation gets more complex as you have to deal with when 2 months from February 29 is and such.

Adding a number to a date always adds days to that date.

-bd

[lidoh]

Hi Live Oak,

Thanks for the tip. I was complicating myself.

Thanks,

Jaime