Add 6 months to Date

[Bill_misc_IT]

I'm running a script to notify via email when an employee reaches their 6 month anniversary. What is the correct 'calculation' to add 6 months to their 'hire date' field?

Is there a simpler way than:

If (month(hire date)<7, month(hire date)+6 &"/"& day(hire date) &"/"& year (hire date),

month(hire date)-6 &"/"& day(hire date) &"/"& year (hire date)+1)

I tried this and it works, but does can cause problems if the calculated month does not have 31 days (or 28 for Feb).

Thanks.

Bill

[doughemi]

Date(Month(hiredate) + 6;Day(hiredate);Year(hiredate))

[comment]

See:

http://fmforums.com/forum/topic/59942-frequency/page__view__findpost__p__284146