Hello All,
Any one know how to change date format in xlsx report .
Now Current date print (yyyy-mm-dd) so i want to change in (dd-mm-yyyy)
so any one suggest me how to achieved this ?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Financeiro
- Inventário
- PoS
- Projeto
- MRP
Esta pergunta foi sinalizada
3
Respostas
11668
Visualizações
Added report_xlsx (https://apps.odoo.com/apps/modules/14.0/report_xlsx/) module from oca and follow this step:
Add below code inside the function:
date_style = workbook.add_format({'text_wrap': True, 'num_format': 'dd-mm-yyyy'})
sheet = workbook.add_worksheet(report_name[:31])
sheet.write(row, col, "Created on: ", bold)
sheet.write(row, col + 1, proj.created_on, date_style)Hope it will work.
Hi, can you specify where to add the above code.. im trying to add in ir_report.py inside def _render_xlsx(self, report_ref, docids, data): this function...but i didn't get any results
Hello All
I am Solve using this:
import datetime
datetime.datetime.strptime(obj.start_date, '%Y-%m-%d').strftime('%d-%m-%Y')
This worked for me, thanks. Also it canbe used to pass only the year from the date format i.e datetime.datetime.strptime(obj.start_date, '%Y-%m-%d').strftime('%Y')
Which place did you add this code
Hi Manish,
you have to change the date format in the language settings
Activate the developer mode > Settings > Translations > Select the language you are using > and in the field "'Date Format" enter the format you want
this will change the format of the date in the entire system and will reflect in printing xls reports
sorry It's not solved my problem.
Está gostando da discussão? Não fique apenas lendo, participe!
Crie uma conta hoje mesmo para aproveitar os recursos exclusivos e interagir com nossa incrível comunidade!
Inscreva-se| Publicações relacionadas | Respostas | Visualizações | Atividade | |
|---|---|---|---|---|
|
1
out. 25
|
12120 | ||
|
2
jul. 24
|
3709 | ||
|
1
jun. 24
|
6016 | ||
|
1
out. 23
|
98 | ||
|
413 Request Entity Too Large
Resolvido
|
|
1
ago. 23
|
2194 |
