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	Replies	Views
create backorder odoo after validate purchase shipment ? Solved odoo11	1 अक्तू॰ 25	12115
I can't create any sub-task odoo11	2 जुल॰ 24	3706
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 Solved odoo11	1 अग॰ 23	2194

This question has been flagged

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