Thread: Syntax
View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Syntax

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

--

Graham Mayor - Word MVP

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


alex wrote:
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