Odoo Help


List view group by date format change

on 11/23/13, 3:11 AM 3,510 views

In Openerp 7 Form Search view Group by Date Shows in the below Format:-

October 2013
November 2013
December 2013

How to change the date format in List view ? Group by.

In reports can use change date format using the sql query to_char(order_date, 'MM-DD-YYYY') as order_date,

But in the Form list view Group by how to change date format?



Solanki Shamji

--Solanki Shamji--

| 5 2 7
Baroda, India
--Solanki Shamji--


Solanki Shamji
On 7/22/15, 2:19 AM


Check with this may be it will help you or you can get idea

<filter string="Order Month" domain="[]" context="{'group_by':'date_order:day'}"/>

can i show weekday instead of :day it gave me error in context i want to show weekday abbr too

Mostafa Abd El Fattah
on 9/20/16, 6:47 AM

Vale Trood

--Vale Trood--

| 5 2 7
Tunis, France
--Vale Trood--

Vale Trood
On 7/23/15, 9:04 AM

Add a filter in your XML like this:

<record id="view_xxx_filter" model="ir.ui.view">

<field name="model">xxxxx</field>

<field name="arch" type="xml">

<search string="XXXX">

<field name="order_date"/>  

<group expand="0" string="Group By...">

<filter string="Date Order" icon="terp-personal" domain="[]" context="{'group_by':'order_date'}"/> 






About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 11/23/13, 3:11 AM
Seen: 3510 times
Last updated: 11/5/15, 12:23 PM