0

I was wondering if someone know if there is a way to change the date format for a field pulled through from Dynamics 365 CRM in a word template.

Basically, I have a date field (via developer, XML Mapping Pane tab) looks like DD-MM-YYYY ("09-09-2021"). I would like the field to be "9 Septembre 2021" when it comes through into word.

Does someone know how to change the date format in word? For example in the developer tab, i am really struggling with it and making a new field in the database is not an options.

hii
  • 77
  • 6
  • "I have a date field (via developer, XML Mapping Pane tab)" - is it a date field or a content control? If it is a date-picker content control (as suggested by XML Mapping Pane) then you can change the date format from the Properties dialog. – Timothy Rylatt Sep 09 '21 at 13:47
  • Its still not working. Maybe because my data has DD-MM-YYYY format and my Word has an english language so maybe it wants DD/MM/YYYY. But I dont know. I will try it next week again – hii Sep 09 '21 at 15:51
  • A lot depends on what the datatype is in the export. If it is just a formatted string you’ll need to reformat it. But if it is exported as a date ***and*** you have mapped it to a date picker content control then you can set the language and date format of the control. There is not enough information in your question to give a definite answer. – Timothy Rylatt Sep 09 '21 at 17:50
  • hi its still not working. I made another question here: https://stackoverflow.com/questions/69176608/making-word-template-from-dynamics-crm-and-change-date-format-merge-field-xml-ma – hii Sep 14 '21 at 11:07

0 Answers0