How to Change date formate in Xlsx report ?[Solved]

Question

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 ?

Kamrul Islam Shahin · Accepted Answer

Added report_xlsx ( https://apps.odoo.com/apps/modules/14.0/report_xlsx/ [1] ) 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.

[1] https://apps.odoo.com/apps/modules/14.0/report_xlsx/

Manish Bohra · Answer

Hello All
I am  Solve using this:
import datetime
datetime.datetime.strptime(obj.start_date ,  '%Y-%m-%d' ).strftime( '%d-%m-%Y' )

Hazem Mahmoud (Rising Systems AG) · Answer

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

Powiązane posty	Odpowiedzi	Widoki
I can't create any sub-task odoo11	2 lip 24	2555
odoo 11 display calendar widget in website layout odoo11	1 cze 24	5020
create backorder odoo after validate purchase shipment ? Rozwiązane odoo11	1 paź 23	10703
Get field's value from another model odoo11	1 paź 23	98
413 Request Entity Too Large Rozwiązane odoo11	1 sie 23	2193

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!