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

İlgili Gönderiler	Cevaplar	Görünümler
I can't create any sub-task odoo11	2 Tem 24	2555
odoo 11 display calendar widget in website layout odoo11	1 Haz 24	5020
create backorder odoo after validate purchase shipment ? Çözüldü odoo11	1 Eki 23	10703
Get field's value from another model odoo11	1 Eki 23	98
413 Request Entity Too Large Çözüldü odoo11	1 Ağu 23	2193

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!