How do I select the records to print by compare the date in the Mailmerge
table ? I need to print those records if the field of the date (in yyyymmdd
format) is over 30 days from todays date. Thanks ....

What version of Word? What is the data source?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Newuser" wrote in message
...
How do I select the records to print by compare the date in the Mailmerge
table ? I need to print those records if the field of the date (in
yyyymmdd
format) is over 30 days from todays date. Thanks ....

My word's version is 2003 and the data source is created by word too ....

"Doug Robbins - Word MVP" wrote:

What version of Word? What is the data source?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Newuser" wrote in message
...
How do I select the records to print by compare the date in the Mailmerge
table ? I need to print those records if the field of the date (in
yyyymmdd
format) is over 30 days from todays date. Thanks ....

This is going to be quite tricky to achieve and the solution is based on
work by Macropod (linked from my web site -
http://www.gmayor.com/insert_a_date_...than_today.htm )

You can use a SKIPIF field to eliminate all records that don't fit the
criteria by adding a complex field structure to your document: Copy the code
from the link and edit it to match that below - that way you will not make
as many mistakes

{ SET DueDate {QUOTE {SET Delay 30}{SET a{=INT((14-{DATE \@ M})/12)}}{SET
b{={DATE \@ yyyy}+4800-a}}{SET c{={DATE \@ M}+12*a-3}}{SET d{DATE \@ 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*10^6+mm*10^4+yy
\# "00'-'00'-'0000"} \@ "yyyyMMdd"} }{ SKIPIF { MERGEFIELD Datefield \@
"yyyyMMdd" } { DueDate } }

Put the name of your date field in the last line in place of 'Datefield'

--

Graham Mayor - Word MVP

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



Newuser wrote:
My word's version is 2003 and the data source is created by word too
....

"Doug Robbins - Word MVP" wrote:

What version of Word? What is the data source?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Newuser" wrote in message
...
How do I select the records to print by compare the date in the
Mailmerge table ? I need to print those records if the field of
the date (in yyyymmdd
format) is over 30 days from todays date. Thanks ....