Mail Merge Reports

Create documents in docx, xlsx (MS Office Word and Excel), odt, ods (LibreOffice and OpenOffice) and pdf format without MS Office or others plugins installed from any module and subpanel using templates.

Includes a 30 day guarantee

Try it Now

#2066 - Set date/time format in .docx document

Closed General Question created by rond 5 years ago

Hi team.

I'm creating a mail merge .docx report and the variable is displayed in MS Word as the following format: 01/25/2018 9:20 AM I want it to display in MS Word as: 25/01/2018

Is this possible and if so how do I do it?

Thank you!

Izertis Provider
5 years ago
Hi,

There are several constants and formats that depends on de language of the template. Each template only can be associated with one language. Depending on the language assigned to the template then dates, numbers and boolean values (Yes/No) will be displayed in a different way.

You can add more languages and modify the configuration for each language available. For this task, please read "Languages" section in the Readme.txt file of the component.

For example, in this case, and supposing you are using templates with US English, you need to modify the 'date_format' config in the 'en_US' section in 'modules/DHA_PlantillasDocumentos/lang_format_config.php' file. This config is defined as
```
&#039;date_format&#039; => &#039;m/d/Y&#039;
```
but you can modify to this
```
&#039;date_format&#039; => &#039;d/m/Y&#039;
```
if you need

Regards
reply

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.

Saving Comment...

Mail Merge Reports

#2066 - Set date/time format in .docx document

"It has improved our processes so much! Admin cut in half! We send a webform to clients to sign up straight into CRM then generate and print their paperwork to sign."

Other add-ons of interest

Glances - Integrate SuiteCRM with all your apps

Enhanced PDF Template

Format Builder