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_

Related Posts	Odgovori	Prikazi
Webhook (odoo18) configuration	1 avg. 25	913
Why does Odoo create a blank record when opening a custom form view and navigating away? configuration	2 avg. 25	423
How can I track hardware repairs with technicians? Receive, diagnose, estimate, repair, invoice, deliver configuration	2 avg. 25	497
Can I use Odoo as an Applicant Tracking System? Recruitment? configuration	3 avg. 25	1311
Appointment booking buffer (gap) setting configuration	1 avg. 25	711

This question has been flagged

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