Skip to Content
This question has been flagged
makotemplateopenerp7sandboxjinja2
2 Respostes
12640 Vistes
Avatar
Juan Formoso Vasco

I've created a mail template (module email_template), I load it before sending the mail (though the email.compose.message wizard) and it's working perfect.

However, in the template I'm showing a field of type date, and it's showing up with the format "%Y-%m-%d %H:%M". The problem is that that's not the date format of my language, I need "%d-%m-%Y %H:%M".

I've tried with ${my_date|dateformat("%d-%m-%Y %H:%M")}, but I've gotten an error. How can I achieve the new format?

Thank you in advance!

Avatar
Descartar
Avatar
Jérémy Kersten (jke)
Best Answer

Hello,

Have you try with tz_format ? From memory, it exists since saas-3 (So, it will not work in V7 :( ).

Example;

${format_tz(object.name,object.employee_id.address_id.tz or 'Europe/Brussels','%m/%d/%Y %H:%M')}

Info:

function format_tz(datetime, tz, format)}

datetime is required:
    Be aware that this will only work with datetime. Not a string, or a date    

tz is optional, function uses:
    - tz param
    - current user tz 
    - UTC

format is optional, function uses:
    - format param
    - format on lang in context
    - '%B-%d-%Y %I-%M %p (tz)'

 

Avatar
Descartar
Juan Formoso Vasco
Autor

Thank you! You've explained it very well, but it's not working, it produces an error when the template is rendered. I'm using OpenERP7, does that work on it?

Jérémy Kersten (jke)

Sorry, it's only since Saas-3, so it will not works... You can use an ugly hack with your date (spliting the string)... Euro Date = ${"%s/%s/%s" % (object.date_order[8:11], object.date_order[5:7], object.date_order[0:4])} Sorry, no more idea

Jérémy Kersten (jke)

FYI: function format_tz(datetime, tz, format)}

Avatar
Erwin van der Ploeg
Best Answer

Somdone from odoo told me it not possible to change format. It is fixed in YYYY-MM-DD. Not implemented by them. 

Avatar
Descartar
Related Posts Respostes Vistes Activitat
How to add footer in mako report?
mako openerp7
Avatar
Avatar
1
de des. 15
5310
object is not callable in mako for OpenERP
mako openerp7
Avatar
0
de nov. 15
4403
AttributeError: 'int' object has no attribute 'get' Solved
mako openerp7
Avatar
Avatar
3
de nov. 15
13785
shortcut button order
xml template openerp7
Avatar
Avatar
1
d’abr. 16
5840
How to call a python function in a mako file
python mako openerp7
Avatar
Avatar
1
de nov. 15
7375