Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mail Merge date field

Status
Not open for further replies.

crpryor1

Programmer
Mar 25, 1999
21
US
Mail Merge with word 2000 and VFP 7.0 DBF. If I have an empty date field word will print 12/30/1899.
thank you
Chuck
 
Hi,

Welcome to DateSerial value of ZERO. You do realize that dates are just NUMBERS that can be FORMATTED to look like whatever date STRING you can imagine.

What value do you want instead? You could do an Edit/Replace after the merge.

Skip,
[sub]
[glasses] [red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?" [tongue][/sub]
 
Thank you
Yes I do know that it can be formatted. The word doc is printed from VFP and the operator does not see the word doc and they cannot edit the doc. 95% of the time there will be a valid date. I need a way to skip this field if it is empty.
thank you
chuck
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top