Date Formatting

[Kushum]

Hi,
I have entered the following for my field "DOB" which is sourced from
MSAccess:
MERGEFIELD DOB \@"dd/MM/yy"
but not all DOB data has been entered:
So wherever there is a blank DOB in the database, it comes up as todays date
in the merged document with the above command.
I would appreciate every help I get.
Thankyou in advance.

 

[Doug Robbins]

Use an If...Then...Else field that checks if DOB is blank

{ IF { MERGEFIELD DOB } = "" "" "{MERGEFIELD DOB \@ "dd/MM/yy"} }

--
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

 

[Kushum]

How do i actually implement this code?

Use an If...Then...Else field that checks if DOB is blank

{ IF { MERGEFIELD DOB } = "" "" "{MERGEFIELD DOB \@ "dd/MM/yy"} }

--
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

 

[Doug Robbins]

In the mailmerge main document, use Ctrl+F9 to insert each pair of field
delimiters { } amd type the text in the positions shown.

Use Alt+F9 to toggle off the display of the field codes.

--
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