I have a little problem with an email template, I include within body_html datetime field, at the time of sending the mail that arrives with the wrong date (over 5 hours) I guess that is the issue of time zones; I have no idea how I can specify in the mail template that should take the user's time zone, I have seen that to address this in the reports with "Aeroo reports" is enclosed in <formatLang(o.f_start, date_time=True)> but for the case of the mail template does not work.
What I can think of at the moment is to create a functional field that returns me the date converted to the time zone of the user but do not think is the most correct way to solve this problem.
I thank you so much any help on the subject.
Not only is the timestamp wrong, it will also use the default formatting (YYYY-MM-DD) instead of the chosen language's format. See also this question : http://help.openerp.com/question/17559/what-is-the-syntax-to-round-numbers-in-the-email-templates/ which is about numbers and getting them formatted correctly.
Another search yielded me : http://help.openerp.com/question/15885/how-to-change-email-templates-date-format/