Date format in Spreadsheets

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

ลูกค้าสัมพันธ์
e-Commerce
ระบบบัญชี
สินค้าคงคลัง
PoS
Project
MRP

All apps

All Posts คน เหรียญรางวัล

แท็ก (View all)

odoo accounting v14 pos v15

เกี่ยวกับฟอรั่มนี้

ช่วยเหลือ

Date format in Spreadsheets

spreadsheets odoo16features

1 ตอบกลับ

1925 มุมมอง

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.

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
Where can we learn about spreadsheet formula’s (v16)? แก้ไขแล้ว spreadsheets odoo16features	4 เม.ย. 25	8012
bug saving on spreadsheet document แก้ไขแล้ว documents spreadsheets odoo16features	9 เม.ย. 25	4085
How to Add wizard under print button inside the form view. odoo16features	3 ส.ค. 25	2731
How to add @api.onchange in _get_view() method odoo 16 odoo16features	1 พ.ค. 25	2691
get all partners which are internal users or portal users odoo16 odoo16features	1 เม.ย. 25	3679