Odoo Help


how can we change date view format from dd/mm/yyyy to mm/dd/yyyy

Ullas A
on 8/16/13, 10:04 PM 10,720 views

by default the date format is seen to be mm/dd/yyyy,. but i need dd/mm/yyyy format .how can i make this change..? can anybody help me please....?(i am a beginner in openerp)


Anas Taji

--Anas Taji--
| 6 7 8
Amman, Jordan
--Anas Taji--

Skype: anas.taji-sw

Email: anas.taji@smartway-jo.com

Anas Taji
On 8/16/13, 10:39 PM

First you need to enable the Technical Features under your user account, then go to Settings->Translations->Languages. Edit your current language and change the date format.


On 4/1/15, 8:13 AM

To have it on your PDF in correct format you have to take care in wich country your Company is located:
Settings - Companies - Your Company Address Field: Country

The Language of that country will be used for your Header and Footer of PDF-Reports.
If you have set e.g. "germany" as Adress of your company then you have to change the format of Language German:

Odoo allows changing date format on a database level for every language. The default date format is MM/DD/YYYY. Suppose you need to change the date format to DD/MM/YYYY. To do the same, perform the following steps.

  1. Navigate to “Settings>Translations>Languages” Menu form Administrator account.

  2. Choose the language for which you want to change the date format from the listandopenitsform view and click on edit to modify.

  3. For the format, MM/DD/YYYY, the entry in date format is “%m%d%y”. To change this to DD/MM/YYYY, we can modify it to “%d%m%y” and click on save.

  4. You can now see any list or form view in the system to see the changes. 

I usualally use this method but with the l10n_hr_in_payroll it not working for payment advice editing. Why?

on 6/12/15, 11:40 AM
On 4/1/15, 6:51 AM

its showing in views(tree view and form view..) like dd/mm/yy its working fine Thank you # ..but  in database it had stored like yy/mm/dd..because im printing a one object value in pdf at that time date has come like yy/mm/dd but i want dd/mm/yy on pdf.... problem is storing data in database.. its storing like yy/mm/dd so when we storing in database i want store like dd/mm/yy so how can i achieve this one??

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

3 follower(s)


Asked: 8/16/13, 10:04 PM
Seen: 10720 times
Last updated: 4/1/15, 8:14 AM