Mail merge issue birth date

Solved
garbiche22 -  
 cg13 -
Hello,

I created a database in Excel with different information, including a "Date of Birth" field. When I am in my Word file and creating a mail merge based on this database, the date is in English format, meaning the order of the numbers is reversed. I went to forums to try to find a solution, and the most common one I came across was modifying the field by adding " \@"dd/MM/yyyy" ". The only result I get is that it shows the current date, indeed in French format, but that is not what I'm looking for.

Does anyone have a solution??

Thanks in advance!!

Maxime

2 answers

Argitxu Posted messages 5292 Registration date   Status Contributor Last intervention   4 834
 
Hello Maxime

The exact syntax is {MERGEFIELD date \@ "dd/MM/yyyy"}
Only the date format is in quotes
After the modification, select and press F9 to update

--
Argitxu
39
cg13
 
Thank you, the response was super helpful and efficient!!
0