Skip to Content
Meniu
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
Această întrebare a fost marcată
1 Răspunde
4693 Vizualizări

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,

Imagine profil
Abandonează
Autor Cel mai bun răspuns

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

Imagine profil
Abandonează
Related Posts Răspunsuri Vizualizări Activitate
4
mar. 16
6583
3
iun. 25
992
1
ian. 25
17892
2
dec. 24
2367
1
nov. 22
6280