Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Phildeman
 
Posts: n/a
Default How do I omit an empty date merge field?

I am getting garbage when a date merge field is empty in word 2002. I have
tried:

{ IF { MERGEFIELD "sdate" } = "" "" "{ MERGEFIELD "sdate" \@"MM/dd/yyyy" }"
} Which indicates, if the merge date field is empty, then display nothing,
else display the value in the merge date field. Yet, it displays,
06/09/2005. I checked the database and their is no value in the field.

The database is SQL Server 2000 and I am using Access 2002 to interface with
SQL Server. Then I am using Word 2002 to interface with Access. When I run
the query that Word is using to perform the merge, the date field displays
the data correctly. I am not having any problems with any other field, only
the date field.
 
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
Date mail merge field KL Mailmerge 1 April 12th 05 11:51 AM
Date Field in Merge Document Karen Hart Mailmerge 35 March 29th 05 12:38 PM
Date mail merge field shows as serial Hiking Mailmerge 5 March 18th 05 10:25 AM
using date field in merge Henri Vrancken Mailmerge 3 March 5th 05 01:52 PM
How do I filter a Dbase date field in a word mail merge documnet? SMATKINS Mailmerge 0 January 27th 05 04:09 PM


All times are GMT +1. The time now is 01:45 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"