Se rendre au contenu
Menu
Cette question a été signalée
1 Répondre
4570 Vues

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.

Avatar
Ignorer
Meilleure réponse

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

Setting>>Translation>>Languages.

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

 

Avatar
Ignorer
Auteur

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'.

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

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.