date fields

S

sherry

i have created a form with merge fields from a foxpro
database. the date fields are formated as dates. when
there is no date for that field word prints 12/30/1899.
how can i get it to remain blank?
 
G

Graham Mayor

A conditional field in place of the date field should do it:

{IF{Mergefield Datefieldname} <> "" "{Mergefield Datefieldname}"}
or just possibly
{IF{Mergefield Datefieldname \@ "yyyyMMdd"} > 18991230 "{Mergefield
Datefieldname}"}


--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
 
S

SHERRY

thank you.
this didn't solve my problem, but led me in the right
direction.
it was a foxpro problem...field needed to be character
instead of date.empty defaults to 12/30/1899.
thanks again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top