Custom Date Format

S

Sue

Access and Word 97
I have an Access database that is serving as a source for
Word merge files. I cannot get the dates to merge into
Word with a mmmm dd, yyyy (January 01, 2003) format.
Can anyone help?
Thanks
 
J

Joan Wild

You should use a query as the source for your merge. You can then put the
following in a blank column of the grid:

Format([YourDateField],"mmmm dd, yyyy")
Substitute the name of your date field for YourDateField in the above.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 mail merge 1
How to change date format when using Word Mailmerge 2
Date format doesnt match from MsAccess 1
UK dates in database appearing as US dates in a mail merge document 2
Date (multiple) format in textbox 1
Forcing a date entry format of dd/mm/yyyy 1
Excel is changing date format incorrectly 7
convert date 1

Top