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 ?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Akuntansi
- Inventaris
- PoS
- Project
- MRP
Pertanyaan ini telah diberikan tanda
3
Replies
10952
Tampilan
Added report_xlsx (https://apps.odoo.com/apps/modules/14.0/report_xlsx/) 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.
Hi, can you specify where to add the above code.. im trying to add in ir_report.py inside def _render_xlsx(self, report_ref, docids, data): this function...but i didn't get any results
Hello All
I am Solve using this:
import datetime
datetime.datetime.strptime(obj.start_date, '%Y-%m-%d').strftime('%d-%m-%Y')
This worked for me, thanks. Also it canbe used to pass only the year from the date format i.e datetime.datetime.strptime(obj.start_date, '%Y-%m-%d').strftime('%Y')
Which place did you add this code
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
sorry It's not solved my problem.
Menikmati diskusi? Jangan hanya membaca, ikuti!
Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!
Daftar| Post Terkait | Replies | Tampilan | Aktivitas | |
|---|---|---|---|---|
|
2
Jul 24
|
2557 | ||
|
1
Jun 24
|
5020 | ||
|
1
Okt 23
|
10704 | ||
|
1
Okt 23
|
98 | ||
|
413 Request Entity Too Large
Diselesaikan
|
|
1
Agu 23
|
2193 |
