Extract date from date/time field in query used with mailmerge.

  • Thread starter Thread starter Pat B
  • Start date Start date
P

Pat B

I've created a query to use with a WORD mailmerge document. To extract the
date only, I used DateValue() which then displays just the date in the query.
But when I pull it into the mailmerge document, it shows the complete date
and time and seconds. How can I get it to just display as it does in the
actual query?
 
I do use the query as the source document for the merge. Somehow I think I
again how to format it in the actual document by using the toggle, but can't
get it to work.
 
I do use the query as the source document for the merge.  Somehow I think I
again how to format it in the actual document by using the toggle, but can't
get it to work.
Click to expand...

You can coerce the date into a string using FORMAT([someDate],"mmm dd,
yyyy") or similar... (choose your own format...) Seems kinda silly,
but I find working with Word codes beyond my patience level.
 
Back
Top