Odoo Help


Date format in CSV export in openerp 7

on 9/3/14, 3:31 AM 1,507 views

how to change the date format of field, while exporting data in csv format i am getting the format like 'yyyy/mm/dd'. How to change to other formats while exporting the files.


Anil R. Kesariya

--Anil R. Kesariya--
| 7 6 8
Rajkot, India
--Anil R. Kesariya--

Odoo Techno Functional Expert

* Engaged with odoo since May - 2012.

* Customise existing module or develop new module base on customer requirement.

* Played key developer role in many past and running projects.

* Expert in requirement gathering of business and transforming requirement into odoo platform.

* Major expertise in core modules, database, report development and theme development.

* Integration expert.

Linkedin  : https://in.linkedin.com/in/anil-kesariya-97b20a66

Anil R. Kesariya
On 9/3/14, 3:41 AM

You can change the date format from main setting go to .


Select your specific language and change the date format overthere so your data will be export in that format and again if you want to revert the date format in main than reset it again.

Hope this will work.



Thanks for your reply, but my current date format is '%d/%m/%Y' , and when i export it is giving the output in '%Y/%m/%d'.

on 9/4/14, 12:09 AM

Maniganda, You can simply change thr format using XLS fomatting options. OpenERP will give you the DB-compatible format, Y-m-d.

Serpent Consulting Services Pvt. Ltd., Serpent Consulting Services Pvt. Ltd.
on 9/8/14, 3:32 PM

Maniganada I apologize , thought that if we change the date format from configuration it will give the same in export, but as I have checked now my from side too its only giving the database compatible format only.

Anil R. Kesariya
on 9/9/14, 1:28 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 9/3/14, 3:31 AM
Seen: 1507 times
Last updated: 3/16/15, 8:10 AM