Date format in Spreadsheets

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Contabilitate
Inventar
PoS
Project
MRP

All apps

All Posts Oameni Insigne

Etichete (View all)

odoo accounting v14 pos v15

Despre acest forum

Suport

Date format in Spreadsheets

spreadsheets odoo16features

1 Răspunde

1803 Vizualizări

whugh@caradon.co.uk

Good afternoon everyone,

I am using 16.0 on Odoo.sh

The date format in Odoo spreadsheets does not match my language. It is set as MM/DD/YY and I don't seem to be able to change this.

I have my language set as English UK, and the date format is %d/%m/%Y. No other languages are activated. In all other areas, dates display correctly in the DD/MM/YY format, except for spreadsheets.

How can I correct this?

Kind regards,

Will

Maciej

I have the same issue and my developers say it just works like that, which is quite annoying. Especially considering that Odoo is a Belgian company and uses a European date notation. Is anyone from Odoo here that could shed some light on that? I'll probably make a ticket in Odoo support, I don't expect it would do anything but it doesn't hurt to try.

Desk Enterprise

How to fix or work around:

No built-in way yet to change date format inside Odoo spreadsheets.
Dates in spreadsheets use a fixed format for now, ignoring locale.

Workarounds:

Format dates as text in your spreadsheet (using formulas) to display DD/MM/YYYY manually.
Export data and use external tools (Excel, Google Sheets) where you can set date format.
Keep an eye on Odoo updates—this is a known limitation and may be improved in future releases.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Înscrie-te

Related Posts	Răspunsuri	Vizualizări
Where can we learn about spreadsheet formula’s (v16)? Rezolvat spreadsheets odoo16features	4 apr. 25	7767
bug saving on spreadsheet document Rezolvat documents spreadsheets odoo16features	9 apr. 25	3919
How to add @api.onchange in _get_view() method odoo 16 odoo16features	1 mai 25	2451
get all partners which are internal users or portal users odoo16 odoo16features	1 apr. 25	3470
How to add decoration color green with bold to a record with a single conditon odoo16features	1 apr. 25	4299

Această întrebare a fost marcată

How to fix or work around:

Enjoying the discussion? Don't just read, join in!