How can I format date in Odoo 8 QWeb report?

Question

The date in my Sales Order is currently showing as:

Fecha: 21/11/2014 16:59:15

I want to show something like this:

Fecha: Surco, 21 de Noviembre del 2014

I tried using t-esc with strftime but that doesn't work:

<span t-esc="o.date_order.strftime('%Y')" />

score 17 · Answer 1 · answered Nov 24 '14 at 16:52

17

Try using:

<span t-field="o.date_order" t-field-options='{"format": "d MMMM y"}'/>

Result: 21 Noviembre 2014

answered Nov 24 '14 at 16:52

Sebastian

171
3

Thank you! That's even better. But how can I format like: "Surco, 21 de Noviembre del 2014" using this method? – César Nov 24 '14 at 17:09
I am also trying to do that. I still can not. – Sebastian Nov 24 '14 at 18:11
Sad, cannot get the format from the LANG variable (or from any), since t-field-options must be a strict JSON object (not a python dict). – Yajo Jul 22 '15 at 10:18

score 8 · Accepted Answer · answered Nov 24 '14 at 15:30

8

It seems like o.date_order it's not a datetime object but a string. Using the time module is the way to go:

<span t-esc="time.strftime('%A, %d %B %Y',time.strptime(o.date_order,'%Y-%m-%d %H:%M:%S'))"/>

answered Nov 24 '14 at 15:30

César

9,939
6
53
74

1

the date format in the t-field-options attribute uses LDML pattern, so {"format": "EEEE d MMMM y"} will get the desired result. http://www.unicode.org/reports/tr35/tr35-dates.html#Date_Format_Patterns – Nehemias Herrera May 29 '15 at 01:54

score 0 · Answer 3 · answered Feb 20 '15 at 12:33

Hear You can also set the custom date formate using function

Add the function in your_report.py file

class member_branch_mov(report_sxw.rml_parse):
    def __init__(self, cr, uid, name, context):
        super(member_branch_mov, self).__init__(cr, uid, name, context)
        self.localcontext.update({
            'time': time,
            'get_formate_header_date':self._get_formate_header_date      
        })


    def _get_formate_header_date(self, objects):
        header_date=''
        if self.end_date:
            date = datetime.strptime(self.end_date,'%Y-%m-%d')
            header_date=date.strftime('%d  %B %Y')
        return header_date.upper()

hear self.end_date comes from the wizard field

Add in your report your_report_view.xml File

 <t t-if="get_formate_header_date(docs)"><span t-esc="get_formate_header_date(docs)" /></t>

How can I format date in Odoo 8 QWeb report?

3 Answers3