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
- Contabilità
- Magazzino
- PoS
- Project
- MRP
La domanda è stata contrassegnata
3
Risposte
10955
Visualizzazioni
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.
Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!
Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!
Registrati| Post correlati | Risposte | Visualizzazioni | Attività | |
|---|---|---|---|---|
|
2
lug 24
|
2561 | ||
|
1
giu 24
|
5020 | ||
|
1
ott 23
|
10705 | ||
|
1
ott 23
|
98 | ||
|
413 Request Entity Too Large
Risolto
|
|
1
ago 23
|
2193 |
