date input format 1/1/04 and want it to print January 1, 2004. Can it be done?

  • Thread starter Thread starter L. T. Portella
  • Start date Start date
L

L. T. Portella

I have a table with one field for date. The format of this date field is
mm/dd/yy that is 1/1/04 for January 1, 2004. My problem is that when I print
it in a word merge document I want it to appear as January 1, 2003 and NOT
1/1/04. Can it be done easily? Thank you
 
Create a query to use as the source for the mail merge.

In the query design grid, enter a calculated field to give you the format
you want:
MyDate: Format([MyField], "Long Date")
substituting your field name for "MyField".

If you want precisely the format in your example, use:
MyDate: Format([MyField], "mmmm d\, yyyy")
 
Create a Query with the Calculated Field:

FormattedDate: Format([DateField], "MMMM d, yyyyy")

in lieu of your DateField

Use this Query as the DataSource for your MailMerge.
 
Back
Top