Syntax

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

alex - 27 Nov 2007 18:53 GMT

Hi Using word with Excel as a datasource:
I want to say: I want to say:

If the data (date of birth) in that cell means the person is over 60yrs,
Then "we welcome volunteers that are more mature", Else "All volunteers
welcome".

{IF {MERGEFIELD DoB}= "=Today()-21900" "we welcome volunteers that are more
mature" "All volunteers welcome"}

Can someone tell me what i have done wrong please

Thanks

A

Reply to this Message

Doug Robbins - Word MVP - 28 Nov 2007 01:41 GMT

I would suggest that you use Excel to determine the age and then use the age
mergefield in your If...then...else construction in Word

{ IF { MERGEFIELD age } > 60 "We welcome volunterrs that are more mature."
"All volunteers welcome." }

Signature

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

> Hi Using word with Excel as a datasource:
> I want to say: I want to say:
[quoted text clipped - 11 lines]
>
> A

Reply to this Message

Doug Robbins - Word MVP - 28 Nov 2007 01:43 GMT

Alternatively, if you are hell bent on doing it in Word, to see how to do
this and just about everything else you might want to do
with dates in Word, check out fellow MVP, Macropod's Date Calc 'tutorial',
at:

http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902

or at the following page of fellow MVP Graham Mayor's website

http://www.gmayor.com/downloads.htm#Third_party

where he has an item titled 'Date and Time Calculations In A Mailmerge'

Signature

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

> Hi Using word with Excel as a datasource:
> I want to say: I want to say:
[quoted text clipped - 11 lines]
>
> A

Reply to this Message

Graham Mayor - 28 Nov 2007 07:09 GMT

See also comparing dates at http://www.gmayor.com/formatting_word_fields.htm

Signature

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

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

> Hi Using word with Excel as a datasource:
> I want to say: I want to say:
[quoted text clipped - 11 lines]
>
> A

Reply to this Message

Rate this thread: