Odoo Help


This community 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.


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

Ullas A
on 8/16/13, 10:04 PM 5,615 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??

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

3 follower(s)


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