date format locale

[Segi]

After reinstalling eBase, my date format has reverted from the American style date format of mm/dd/yyyy to the European format of dd/mm/yyyy but I want the date to be in the American date format.

In the designer I went to Tools->System Preferences->Internationalization. English is set to the default and when I click on Properties, it shows the short date format in the format that I want it to be in mm/dd/yyyy but date fields are being formatted in the other format. Is there another configuration file that has to be edited to force eBase to use the date format that I want it to be in ?

I have a query (which hasn't changed at all since I reinstalled eBase) which returns a date in the format yyyy-mm-dd. Before reinstalling eBase recently it would properly format this date in the American format but now it is converting it to dd/mm/yyyy.

[Jon]

The display of a field of type DATE is controlled by the Formatting language within the dialog you mentioned. This should be set to en or en_US, but it sounds like you already have this. You shouldn't need to do anything else, the change should be picked up immediately. The new date format will only be shown for new forms - any running form will continue to show the original format.

There is also a property Ufs.dateFormat in UFSSetup.properties in tomcat/webapps/ufs on the server, but I think this is only used when setting date literals using FPL, so I don't think this is causing your problem.

You could try restarting the server if all else fails.

Regards
Jon

[Segi]

Jon,

I just restarted the server and eBase is still not using the internationalization format that I specified

Edit: Jon, I checked again in UFSSetup.properties and found the line that you mentioned. It was in the format dd/mm/yyyy. I changed it to mm/dd/yyyy and restarted the server and now it works as expected. Apparently, that's not FPL specific. I don't use FPL at all in any of my scripts.

[Jon]

So it seems. That doesn't sound right to me so I'll get it checked out.