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

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
I can't create any sub-task odoo11	2 heinäk. 24	2555
odoo 11 display calendar widget in website layout odoo11	1 kesäk. 24	5020
create backorder odoo after validate purchase shipment ? Ratkaistu odoo11	1 lokak. 23	10703
Get field's value from another model odoo11	1 lokak. 23	98
413 Request Entity Too Large Ratkaistu odoo11	1 elok. 23	2193

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!