Increasing a Merged Date field from Access Db

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sk - 14 Mar 2004 04:54 GMT

Anyone know how to increase the value of a merged date
field (from an Access Db)
eg

on an invoicing template where a dates "from" & "to" are
required, the "from" is merged from an Access Db but
the "to" needs to be calculated from the "from" value -
eg from 1/1/04 (Db merge value) to 1/2/04 (1 month added
to "from" value

Help greatly appreciated

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 14 Mar 2004 07:17 GMT

The best way to do this is to use a query in access in which you use the
DateAdd function.

Databases are better at manipulating data than word processors.

Signature

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

> Anyone know how to increase the value of a merged date
> field (from an Access Db)
[quoted text clipped - 7 lines]
>
> Help greatly appreciated

Reply to this Message

sk - 14 Mar 2004 09:33 GMT

Much appreciated Doug

----Original Message-----

>The best way to do this is to use a query in access in which you use the
>DateAdd function.
[quoted text clipped - 14 lines]
>
>.

Reply to this Message

macropod - 15 Mar 2004 12:23 GMT

Hi sk,

You can also do this in Word using a field:
{QUOTE{SET Delay 1}{SET mm{=MOD({DATE \@ M}+Delay-1,12)+1}}{SET yy{={DATE
\@ yyyy}+INT((Delay+{DATE \@ M}-1)/12)}}{SET dd{=IF(({DATE \@
d}>28)*(mm=2)*((MOD(yy,4)=0)+(MOD(yy,400)=0)-(MOD(yy,100)=0))=1,28,IF((mm=4)
+(mm=6)+(mm=9)+(mm=11)+({DATE \@ d}>30)=1,30,{DATE \@
d}))}}{=dd*10^6+mm*10^4+yy \# "00'-'00'-'0000"} \@ "dddd, d MMMM yyyy"}
where the braces are entered as matching pairs via Ctrl-F9.

You can download a document for doing this and other date & time
calculations at:
http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=249902
(url all one line)

Cheers

> Anyone know how to increase the value of a merged date
> field (from an Access Db)
[quoted text clipped - 7 lines]
>
> Help greatly appreciated

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 15 Mar 2004 12:28 GMT

If you're a masochist, that is. Access has a built-in DateAdd(<period>,
<number>, <date>) function.

Signature

> Hi sk,
>
[quoted text clipped - 30 lines]
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.614 / Virus Database: 393 - Release Date: 5/03/2004

Reply to this Message