by Izertis

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 a year 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!

  1. dharma member avatar

    Izertis Provider

    a year 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

    'date_format' => 'm/d/Y'
    

    but you can modify to this

    'date_format' => 'd/m/Y'
    

    if you need

    Regards

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
  • "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."

    Read More Reviews