Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
1 Balas
4680 Tampilan

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,

Avatar
Buang
Penulis Jawaban Terbai

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

Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
4
Mar 16
6580
3
Jun 25
987
1
Jan 25
17877
2
Des 24
2359
1
Nov 22
6259