Word 97 Date Calculations

[Weber]

I have a merge field named Effective and I want to add one month to the date (ie 11/15/2000 becomes 12/15/00). The following formula does this except for December effective dates. When Effective date is equal 12/15/2000 the formula results in 13/15/2000. Is this a problem with Word or am I doing something wrong?

{Set MyDate {MERGEFIELD Effective }}{={MyDate \@ "M" } +1 }
{MyDate \@ "\d"}/{MyDate \@ "yyyy"}

Thanks

 

[Dreamboat]

No offense, Weber, and I should be able to tell you how to do this, but I can't. I'm not even sure it CAN be done. I'd put the field in the data source.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[Weber]

I don't think it can be done in Word but I thought I'd ask. Word and dates don't get along very well.

Thanks for responding.