date SWITCH ("MMM. DD, YY)

[MarkBeck]

Hi

I use a fieldswitch to present a date in a DATE format given by word. The data is in a mailmerge and the dates are "good dates" from excel.

For some reason it does not work, and return the serial number of the date instead.

All other numeric switch work well.

Can anyone help?

Mark

 

[dcompto]

The following from the mvps.org site fixed the problem for me...

If you’re having trouble with number and/or date formats from Excel or Access data sources, you’ll want to link to the data in the way Word 97 and Word 2000 did. Go to the General tab of Tools | Options and activate “Confirm conversion at Open.” After you select your spreadsheet or database in the Open Data Source dialog box, you’ll be presented with a list of data link methods. Choose DDE (or ODBC if you used to use that).