Update a date merge field - Urgent help required please

[Caroline]

Hi,

I have an access table with a date field. This date field
needs to be entered as a merge field in cell 1 in a word
document - the next cell has to have this date + 1, the
next has to have this date + 2 etc. 12/04/04, 13/04/04,
14/04/04 etc
Is this possible? If so could someone give me some
guidance please.

 

[Graham Mayor]

Date calculations in fields are very complicated - see
http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=249902

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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Caroline]

Thank you very much for your help - I agree though - it
does look VERY complicated!

 

[Doug Robbins - Word MVP]

Use the DateAdd function in an Access Query and use that Query as the
datasource.

Databases are better at data manipulation than word processors.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[macropod]

Hi Caroline,

The example from the DateCalc document that would meet your needs is found
under 'Date Calculations In A Mailmerge' After inserting that field once,
you can use a cut-down version of it for the subsequent calculations:
{QUOTE{SET jd{=jd+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)}}
{QUOTE{=dd*10^6+mm*10^4+yy \# "00'-'00'-'0000"} \@ "dddd, d MMMM yyyy"}}

Cheers
If you were to create all of the dates that need to be displayed in your
mailmerge source, you'd have to merge each of those dates individually.