[Graham Mayor]

Adding days to dates in fields is extremely complicated and not simply a
question of adding '2'. See macropod's document on the subject at
http://www.gmayor.com/downloads.htm#Third_party Copy the relevant field
construction to your document and in it replace DATE with Mergefield
CourseDate and set the delay to 2 which will give you something like:

{QUOTE
{SET Delay 2}
{SET a{=INT((14-{MERGEFIELD COURSEDATE \@ M})/12)}}
{SET b{={MERGEFIELD COURSEDATE \@ yyyy}+4800-a}}
{SET c{={MERGEFIELD COURSEDATE \@ M}+12*a-3}}
{SET d{MERGEFIELD COURSEDATE \@ d}}
{SET
jd{=d+INT((153*c+2)/5)+365*b+INT(b/4)-INT(b/100)+INT(b/400)-32045+Delay}}
{SET e{=INT((4*(jd+32044)+3)/146097)}}
{SET f{=jd+32044-INT(146097*e/4)}}
{SET g{=INT((4*f+3)/1461)}}
{SET h{=f-INT(1461*g/4)}}
{SET i{=INT((5*h+2)/153)}}
{SET dd{=h-INT((153*i+2)/5)+1}}
{SET mm{=i+3-12*INT(i/10)}}
{SET yy{=100*e+g-4800+INT(i/10)}}
"{dd}-{mm}-{yy}" \@ "d MMMM yyyy"}

which is why you need to copy it

--

Graham Mayor - Word MVP

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


Ren wrote:
I am merging a date from Access into Word and i want it to say the
date two days after the date in the database. I'm using the following
for the merge field:

{ Mergefield CourseDate \@ "d" } \* ordinal } { Mergefield CourseDate
\@ "MMMM, yyyy" }

but i can't figure out where to add the "+2" bit.

[Ren]

Thanks for both of your relpies - sounds like the most simple way is to add a
field into Access

"Graham Mayor" wrote:

Adding days to dates in fields is extremely complicated and not simply a
question of adding '2'. See macropod's document on the subject at
http://www.gmayor.com/downloads.htm#Third_party Copy the relevant field
construction to your document and in it replace DATE with Mergefield
CourseDate and set the delay to 2 which will give you something like:

{QUOTE
{SET Delay 2}
{SET a{=INT((14-{MERGEFIELD COURSEDATE \@ M})/12)}}
{SET b{={MERGEFIELD COURSEDATE \@ yyyy}+4800-a}}
{SET c{={MERGEFIELD COURSEDATE \@ M}+12*a-3}}
{SET d{MERGEFIELD COURSEDATE \@ d}}
{SET
jd{=d+INT((153*c+2)/5)+365*b+INT(b/4)-INT(b/100)+INT(b/400)-32045+Delay}}
{SET e{=INT((4*(jd+32044)+3)/146097)}}
{SET f{=jd+32044-INT(146097*e/4)}}
{SET g{=INT((4*f+3)/1461)}}
{SET h{=f-INT(1461*g/4)}}
{SET i{=INT((5*h+2)/153)}}
{SET dd{=h-INT((153*i+2)/5)+1}}
{SET mm{=i+3-12*INT(i/10)}}
{SET yy{=100*e+g-4800+INT(i/10)}}
"{dd}-{mm}-{yy}" \@ "d MMMM yyyy"}

which is why you need to copy it

--

Graham Mayor - Word MVP

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


Ren wrote:
I am merging a date from Access into Word and i want it to say the
date two days after the date in the database. I'm using the following
for the merge field:

{ Mergefield CourseDate \@ "d" } \* ordinal } { Mergefield CourseDate
\@ "MMMM, yyyy" }

but i can't figure out where to add the "+2" bit.