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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
Format(MyDateField, "mmmm dd, yyyy")

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