Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
AdamT
 
Posts: n/a
Default How do I compare later/earlier dates in a mail merge IF field?

I'm trying to create an IF field in a mail merge to display one of two
paragraphs depending on whether the Date of Birth field in a record is after
a certain time. I've tried using:

{ IF { MERGEFIELD Date_Of_Birth } 01/07/1976 "Text1" "Text2" }

(The date format above is UK, i.e. dd/MM/yyyy)

....but Word always seems to treat the date as a number, and so any date
later than the first of a month counts as a positive, irrespective of month
or year.
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I mail merge to EMAIL from MS Word AND add a pdf attachment Lily@Insight Mailmerge 24 January 15th 07 09:33 PM
Adding a field to an Off 97 mail merge using Office Pro 2003 TomC Mailmerge 1 January 5th 06 08:00 AM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
How do I compare dates in a Word IF field? Marion G Microsoft Word Help 0 December 10th 04 01:49 AM
How do I compare dates in a Word IF field? Marion G Microsoft Word Help 0 December 10th 04 01:47 AM


All times are GMT +1. The time now is 11:38 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"