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

[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?

 

[KARL DEWEY]

Try using the query for the merge.

 

[Pat B]

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.

 

[Piet Linden]

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.

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.