Mergefield question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MDI Anne - 07 Jul 2006 19:02 GMT

I have a database created in Access, and am pulling info from it to create
letters. I have an expiration date in the database that, when put into my
letter, I would like to add 1 year to the date. {MERGEFIELD "Expiration_Date"}

I've tried doing a +1, and variations of that, but am getting no where. Any
help would be greatly appreciated.

Thanx!!

Reply to this Message

macropod - 08 Jul 2006 00:34 GMT

Hi MDI Anne,

The MERGEFIELD solution depends on whether you're dealing with a day, month
& year, month & year or just a year. If its the last of these, it's simply a
matter of embedding your MERGEFIELD in a FORMULA field coded like:
{={MERGEFIELD "Expiration_Date"}+1}
For anything more complicated, check out the entries under 'Calculate a
month and year, using n years delay' and 'Calculate a day, date, month and
year, using n years delay' in my Date Calc 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902
To use either of those fields, you could replace the 'DATE' references with
your {MERGEFIELD "Expiration_Date"} field. Alternatively, you could add
another SET field, like:
{SET ExpDate {MERGEFIELD "Expiration_Date"}}
immediately above or below the '{SET Delay 1}' line and replace the 'DATE'
references with 'ExpDate'.

Cheers

Signature

macropod
[MVP - Microsoft Word]

> I have a database created in Access, and am pulling info from it to create
> letters. I have an expiration date in the database that, when put into my
[quoted text clipped - 4 lines]
>
> Thanx!!

Reply to this Message

MDI Anne - 10 Jul 2006 14:43 GMT

Mac...

Have tried your formula suggestion and I get the following... !Syntax Error, {

and yes, all that I want to do is add a year to the date...

> Hi MDI Anne,
>
[quoted text clipped - 25 lines]
> >
> > Thanx!!

Reply to this Message

Graham Mayor - 10 Jul 2006 15:06 GMT

You will get a syntax error if you haven't entered it correctly. You need to
use CTRL+F9 for the field boundaries.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Mac...
>
[quoted text clipped - 36 lines]
>>>
>>> Thanx!!

Reply to this Message

MDI Anne - 10 Jul 2006 15:26 GMT

Graham, you were totally correct! So, I entered it in using the
CTRL+F9...now all I get is the number 1.

This is so frustrating, not because of the awesome help I'm getting, but
because I know things can be done...but only know enough to get myself into
trouble! :)

> You will get a syntax error if you haven't entered it correctly. You need to
> use CTRL+F9 for the field boundaries.
[quoted text clipped - 39 lines]
> >>>
> >>> Thanx!!

Reply to this Message

Graham Mayor - 10 Jul 2006 16:00 GMT

That's what will happen if the expiration date is a complete date and not
simply a year. You need to read the link macropod posted and download his
date field file - then modify the appropriate field as indicated earlier in
the thread.

You should be able to get away with

{MERGEFIELD Expiration_Date \@ "d MMM "}{={MERGEFIELD Expiration_Date \@
"YYYY"} + 1}

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Graham, you were totally correct! So, I entered it in using the
> CTRL+F9...now all I get is the number 1.
[quoted text clipped - 54 lines]
>>>>>
>>>>> Thanx!!

Reply to this Message