date fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sherry - 12 Jan 2004 16:46 GMT

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?

Reply to this Message

Graham Mayor - 12 Jan 2004 17:22 GMT

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

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

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

Reply to this Message

SHERRY - 14 Jan 2004 15:08 GMT

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

>-----Original Message-----
>A conditional field in place of the date field should do it:
[quoted text clipped - 10 lines]
>
>.

Reply to this Message