Datetime in Email wrong

Question

I have a problem with the date when I realized a book of a room in Odoo. When I am going to do a book, in my form I can select a date with an specific hour, for example:
Start date: 18/08/2025 13:00:00
Finish date: 18/08/2025 13:00:00
But I created an email with the date, and I recived a wrong hours, I think that it is because the timezone is diferent in server and here, but I don´t know how to solve this.
The email received have this:

Hola ssss,
Gracias por tu reserva. Te confirmamos que tu re

Cybrosys Techno Solutions Pvt.Ltd · Accepted Answer

Hi,

Odoo stores all datetimes in UTC in the database.

The user interface converts those datetimes to the user’s timezone (set in their preferences).

When you send an email and directly insert a datetime field (e.g. ${object.start_date}), Odoo sends the raw UTC value unless you explicitly format it.

That’s why you see a “wrong” hour in the email — it’s showing UTC, not your local timezone.

You need to format the datetime with timezone conversion in the email template.
Try the code,
${format_

İlgili Gönderiler	Cevaplar	Görünümler
Webhook (odoo18) configuration	1 Ağu 25	896
Why does Odoo create a blank record when opening a custom form view and navigating away? configuration	2 Ağu 25	412
How can I track hardware repairs with technicians? Receive, diagnose, estimate, repair, invoice, deliver configuration	2 Ağu 25	490
Can I use Odoo as an Applicant Tracking System? Recruitment? configuration	3 Ağu 25	1294
Appointment booking buffer (gap) setting configuration	1 Ağu 25	700

Bu soru işaretlendi

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