mail merge-convert 3/4/06 into March 4, 2006

[diros]

I use Office 2000. Mail merging from Word, I wish to convert dates in
msaccess which are in short format ie 3/4/06 to appear in the merged word
document as text dates, i.e. March 4, 2006. I am not a programmer. Help
would be greatly appreciated.

 

[Douglas J. Steele]

Create a query, and use the Format function on your date field (not the
Format property of the field).

Mail-merge the query, not the table.

 

[diros]

Looking at Help in Access for function, date and multiple variations, I did
not see an appropriate example. "Long" is close, but I don't want the
weekday inserted. I would appreciate provision of appropriate syntax with a
field name entitled startdate. Thanks in advance for any help provided.

 

[Douglas J. Steele]

Format(MyDateField, "mmmm dd, yyyy")

If you only want Jan, Feb, Mar, use mmm dd, yyyy instead.

 

[diros]

Got it. Syntax works perfectly. Thanks for the follow up.