Skip to Content
Menu
This question has been flagged
2 Replies
10446 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?

Thanks

Avatar
Discard
Best Answer

Hello,

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'}"/>

Avatar
Discard

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

Best Answer

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'}"/> 

</group>

</search>

</field>

</record>

Regards.

Avatar
Discard
Related Posts Replies Views Activity
1
May 18
8539
1
May 16
7972
1
Jul 23
1803
2
Apr 21
15305
0
Dec 16
2470