I want to change the thousands and decimal separators and date formats in order to be used in the Spreadsheets. However, after changing them in the Translation settings and applying the change, the Spreadsheets formats are still in the default format. What should I do?
Odoo is the world's easiest all-in-one management software.
 It includes hundreds of business apps:
- CRM
- e-Commerce
- Бухоблік
- Склад
- PoS
- Project
- MRP
Це запитання позначене
Hi,
The default date format is MM/DD/YYYY. Suppose you need to change the 
date format to DD/MM/YYYY. To do the same, perform the following steps.
1. Navigate to the “Settings>Translations>Languages” Menu from the Administrator account.
2.
 Choose the language for which you want to change the date format from 
the list and open its form view and click on edit to modify.
3. For 
the format, MM/DD/YYYY, the entry in date format is “%m%d%y”. To change 
this to DD/MM/YYYY, we can modify it to “%d%m%y” and click on save.
OR 
You can use this code.
1 . For forms or tree view use the widget ''date"
2 . For reports or qweb use
for t-esc ->  
for t-fields -> 
Hope it helps
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Реєстрація| Related Posts | Відповіді | Переглядів | Дія | |
|---|---|---|---|---|
|  | 1 серп. 25  | 625 | ||
|  | 3 черв. 25  | 3825 | ||
|  | 0 бер. 24  | 3963 | ||
|  | 3 жовт. 24  | 6028 | ||
|  | 0 серп. 23  | 3708 | 
