Skip to Content
This question has been flagged
5 Replies
1244 Views
Avatar
John Roy A. Geralde

The Odoo 19 Datepicker format default is MMM d.  It could have been better left as MM/dd/YYYY.

Changing the date format is desperating

Avatar
Discard
Paul K

So what happens if the date is not in the same year?  Will it display it then?

I don't mind a format change, but would like to have the option to set it myself.  The language settings don't persist to the date picker.  We are running SaaS, and I can update the fields in Studio, but there are tons of them!  Why can't I do this globally?

Paul K

Changing the language settings does not affect the date display in the various fields (and there are many!).  Is there a global way to enact this change without changing each field individually?

Hugo Mercado (Amaris)

The Javascript solution given earlier only works in form views, what can I do with list views?

They should have made it optional really

Avatar
JB
Best Answer

Hello,

Go to settings  >>>  Translations  >>>  Languages 


Avatar
Discard
Avatar
Louis Politanski
Best Answer

There seems to be no global setting allowing you to display dates in a numeric format by default at the moment, which is really unfortunate in my opinion.

You can still display individual dates numerically in XML using options :

<field name="your_date_field" options="{'numeric': true}"/>

If you want numeric dates and datetimes by default, you can load this code in a module loaded after web :

import { patch } from "@web/core/utils/patch";
import { DateTimeField } from "@web/views/fields/datetime/datetime_field";

patch(DateTimeField, {    
	​defaultProps: {        
	​	​showSeconds: false,
	​	​showTime: true,
	​	​// Numeric dates by default
	​	​numeric: true,    
	​},
});

(you can still switch to text format for individual XML fields by using 'numeric': false in options with this patch) 

Avatar
Discard
Avatar
John Roy A. Geralde
Author Best Answer

Where can I get that javascript override to change the datepicker format? I prefer to have it in MM/dd/YYYY because in the report during the printing, old documents will not show the date.  (I can create a computed field though but takes extra coding).


​In the Philippines, the government requires that invoices will have full dates.  An invoice without full date is considered a violation of Internal Revenue policies.


Avatar
Discard
Ray Carnes (ray)

Reports always show the full date.

Avatar
Ray Carnes (ray)
Best Answer

We changed the date format in Odoo 19 based on user interface/user experience research showing that including a textual representation of the month is easier and more reliable to interpret than all-numeric formats. It reduces cognitive load on Users.

For any date field or date time field in Odoo 19 you can hover over it to see the traditional format:


Avatar
Discard
marek.mokrzycki@acdlink.pl

Hi, I am a newbie here, just in fact testing and learning Odoo to see if I can use it in my small new company. Seeing that I cannot easilly set the prefered date format in all views came as a big surprise and dissapointment. People from various regions are used to various ways of displaying the date, and forcing everybody to use a format often totally different from the standard they are used to increases the cognitive load, instead of decreasing it. For me it poses a problem.

Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

In Odoo 19, the datepicker defaults to MMM d (e.g., Sep 18) because it uses the Luxon library with localized formats, which can be confusing compared to the old MM/dd/yyyy. You can change this by editing the Language → Date Format in settings, but the picker may still show abbreviated months. The most reliable fix is a small JavaScript override in a custom module to force MM/dd/yyyy everywhere..





Hope it helps

Avatar
Discard