Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date Fields in Mail Merge with Word
Message
 
To
02/02/2000 15:27:43
Mary-Ann Trinidad
Bercen, Inc.
Cranston, Rhode Island, United States
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Re: Date Fields in Mail Merge with Word
Miscellaneous
Thread ID:
00326356
Message ID:
00326832
Views:
20
Mary-Ann,

I would take and perform your query against your table and in the query do a DTOC() using an IIF() statement to convert the data.

SELECT IIF(EMPTY(datefield),"UNAPPROVED",DTOC(datefield)) AS DateField FROM table INTO CURSOR cCursor
Rich Simpson
Arnold, MO
Mind's Eye, Inc.

Mind's Eye Report Engine Page
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform