This is driving me crazy. I don't know how anyone outside the US or Europe is expected to use OpenERP if it not easier to change the date format. I've read all the previous posts and have had limited and unpredictable success.

I've tried the following:

1) Change the date format and language code in admin=>translations=>app terms=>all terms=>languages.
This worked once in the windows version, but I have not been able to get it to work under Ubuntu

2) changed the LANG item in .openerprc - this works until the client is exited when it is automatically changed back to en_US

How can you have different users logged in with different date formats if none of the modules recognize the date format specified for the language nominated for the user? Surely this issue must have been solved by version 5! Or am I the only person outside Europe/US using the product! (i hope not). Please can someone give me a definitive answer to this so I can get on to some decent testing.

Sorry for the rant but I'm totally frustrated.

Hi,
try to use like this...if you want to change in report & you are getting value from wizard make method.............
1-report.py
def get_date_format(self,form):
#comp_obj=pooler.get_pool(self.cr.dbname).get('res.company').browse(self.cr,self.uid,form['company_id'])
end_date = mx.DateTime.strptime(form['date_to'],"%Y-%m-%d").strftime("%d-%m-%Y")
print "BEFORE CHANGE DATE*******",end_date
return end_date

2- def __init__(self, cr, uid, name, context):
super(report_trial_balance, self).__init__(cr, uid, name, context)
'start_date':self.get_date_format,

})
self.context = context


3-call this method in rml
<td>
<para style="terp_header_Centre">From : [[ get_company(data['form']) ]] To : [[ start_date(data['form']) ]]</para>
</td>

I'm not sure the last reply was an answer to my question.

I have managed to resolve the issue but I don't understand why it worked. The problem was that changing it in the LANG item in the .openerprc file had no effect since when the client exited it changed it back to its original value. However, when I changed the language in the admin settings in OpenERP to en_AU, exited the client, changed the LANG item again in the .openerprc file then ran the client again, then LANG item in .openerprc was no longer overridden. It was also possible to then have different users using different languages with different date formats.

This seems a bit strange to me an I would like it if some one could give a definitive explanation.

Hello,
I am not giving you solution for hit & trial........I am using it in my report.

regards

Thanks for the reply Jitu.

It looks like you are solving the problem for reports and at quite a low level. I am no expert at the module/report development level yet (hope to be later though), and was looking for a definitive solution at the application level without resorting to Python or OpenObject code.

Try to run your client with
LANG=en_US ./openerp-client.py

en_US is locale for US. you can set your locale there. It will display date and amounts in your locale format.

I am noticing the same thing. I can change the language in .openerprc, but it gets changed back when you exit the client.

What's the point in a configuration file that the client changes back to ITS preferred settings instead of YOUR defined settings?

The only way I can think of to set the locale is to edit this file and then chmod so that your user can no longer edit it. which is absurd.

BTW using "LANG=en_US ./openerp-client.py" prevents the client from opening at all.

MattLG

Hi,
can you try in this function....in return[return '%d/%m/%Y'] put what ever format you want e.g. I needed indian format so "%d/%m/%Y"
fikename: datetime_util.py
function
def get_date_format():
"""Return locale date format string. If format string doesn't contain
any of the `%Y, %m or %d` then returns default datetime format `%Y/%m/%d`
"""

fmt = locale.nl_langinfo(locale.D_FMT)
for x,y in [('%y','%Y'),('%B',''),('%A','')]:
fmt = fmt.replace(x, y)

if not (fmt.count('%Y') == 1 and fmt.count('%m') == 1 and fmt.count('%d') == 1):
return '%d/%m/%Y'

return fmt

The first thing to note is that the date format specified in the language dialog (administration->translations->application terms->languages) is referring to the format to be used in reports and not on the data entry forms. The data entry forms date format is determined firstly by the language code specified in the language dialog with the proviso that the language code must be the code of a language that is installed on the server's machine. To find out all the languages installed on your machine go to the command prompt and enter "locale -a". It is also a good idea to restart the client after changing the language code - I've had to restart a couple of times occasionally.

I've had no trouble using different date formats using the above information.

Changing the date for the form does not work as it should be in OpenERP.

When does it work?
It works if you switch the language of the user to the appropriate language, which has been installed in OpenERP. Using the menu Preferences in the client application will change all language preferences and it show the date formatted the appropriate way.

When does it fail?
If you wish to have the language English, but you wish to have different date format. This is like having the menues in English, but the date should be formatted the german way. In this case the formatting will still remain the english way.

Editing .openerprc in your home directory does not help, since it will be overwritten, whenever you close the client application.

This is a clear feature request.

It has by the way nothing to do with the regional settings of the system.

A small workaround for english with a european format would be:

1. Go to Administration -> Translations -> Application terms -> Languages
2. Edit the english language
3. Change en_US to en_GB

Mgazel, that one was easy to follow and perfectly solved the issue.

Just one remark: Check that the user accounts have Language = English, with an empty field as in my case it did not work.

That is correct.

The better solution would be even to create two languages English US and English GB, because sometimes OpenERP will default to en_US and in this case it will not find it.

Hello this solution is working for me only on the client but when I use a report for example the invoice report, I have a bug that the report is looking for format en_US.

Any idea?

André

Please change the format for reports in the Administration -> Translation and set the date values to what you want.