跳至内容
菜单
此问题已终结
1 回复
4709 查看

Hii,

In one of my xml list view, want to show a date in quarters. 

<field name="create_date" string="Quarter" />

How to format the date field to show like Q3 2019 instead of the date?

Thanks,

形象
丢弃
编写者 最佳答案

I done it the following way. Added new custom field by inheriting the hr.appraisal.

appraisal_quarter = fields.Char(string='Quarter', compute='_get_appraisal_quarter')
@api.multi
    def _get_appraisal_quarter(self):
    for appraisal in self:
        appraisal_date = appraisal.date_close
        month = appraisal_date.month
        year = appraisal_date.year
        if 0 <= int(month) <= 3:
            appraisal.appraisal_quarter = 'Q1 ' + str(year)
        elif 4 <= int(month) <= 6:
            appraisal.appraisal_quarter = 'Q2 ' + str(year)
        elif 7 <= int(month) <= 9:
            appraisal.appraisal_quarter = 'Q3 ' + str(year)
        elif 10 <= int(month) <= 12:
            appraisal.appraisal_quarter = 'Q4 ' + str(year)
        else:
            appraisal.appraisal_quarter = 'NA'
# list view
<field name="appraisal_quarter" />
result: Q3 2019

形象
丢弃
相关帖文 回复 查看 活动
4
3月 16
6593
3
6月 25
1022
1
1月 25
17913
2
12月 24
2392
1
11月 22
6299