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

Related Posts	Відповіді	Переглядів
create backorder odoo after validate purchase shipment ? Вирішено odoo11	1 жовт. 25	12114
I can't create any sub-task odoo11	2 лип. 24	3705
odoo 11 display calendar widget in website layout odoo11	1 черв. 24	6013
Get field's value from another model odoo11	1 жовт. 23	98
413 Request Entity Too Large Вирішено odoo11	1 серп. 23	2194

Це запитання позначене

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