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

  1. Argitxu Posted messages 5292 Registration date   Status Contributor Last intervention   4 843
     
    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
    1. cg13
       
      Thank you, the response was super helpful and efficient!!
      0