Hi there,

i am new to mail merges but i am trying to create some template style
merged documents for some users i support.  i have created an IF
statement using the Insert Merge Field option from the mail merge
toolbar.

its a simple statement which compares date1 and date2. if date1 is
earlier thatn date2, print textA. if date2 is earliest, pring textB.

There are a couple of people in my text file, for whom dates 1 & 2
fall in this sort of pattern:  date1= 2 Jan 03   date2 = 1 Jan 04.

The IF statement does not work for the above. Its as if it only looks
at the day and month parts of the whole date and it discounts the
year. So whereas, in the above example date1 is actually earlier than
date2, it will behave as if date2 is earliest.

i have tried this using dd/mm/yy, mm/dd/yy, dd/mm/yyyy & mm/dd/yyyy.
this problem ocurrs for dates entered manually within my IF statement,
as well as if i source them from my text file so i am fairly confident
that this is not a source-file-related issue.

if anyone can help me or give my any advice, i'd be v grateful.

thanks & regards
Georgina