I need UK date formats but keep getting US formats

[eo]

Hi

I am on BOExi, CR10 and CRxi.

I have made the following changes:

Changed the regional settings on the BOExi server to:
1) In the Regional Options tab:
a) Strandards and formats - English (United Kingdom)
b) Location - United Kingdom
2) In the Advanced tab:
a) Language for non-unicode progs - English (United Kingdom)

Changed the ODBC Connection (configuration):
1) Language of SQL server system messages - British English
2) Use regional settings when outputting currency, numbers, dates and times - TICKED

Does anyone know how to rectify this? It is very important I get this resolved urgently? Is there a setting elsewhere in BOE itself where I should be doing this.

I have rechecked my reports using CR10 and CRxi, not running them using BOExi, and that works fine, so it's almost certainly BOExi specific.

EO
Hertfordshire, England

 

[dgillz]

Under File, Options, Fields, Choose Date/Time, and the format of your choosing. In may case a UK or European date format is not available, but it is easy to build with the Customize option.

From then on any date/time field you insert into a report will be formatting in this manner.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[eo]

I take it you mean I need to change this in CR.

I navigated to File, Options, Fields, Choose Date/Time, and it defaulted to System Default Short Format, which provided a sample of 01/03/1999 13:23:45 (which is the same as March 1, 1999 13:23) - so this is already correct.
As I said in my post, I tested the reports using CR directly, this has never been a problem through CR, the problem comes when I publish and generate the report through BOExi (Enterprise). This makes me think that the server's settings is okay, but there must be some clandestine setting in Enterprise somewhere where this change must be made.

EO
Hertfordshire, England

 

[Madawc]

What you could do is convert the dates into text, using Totext({your.date}, "dd/MM/yyyy"). BOExi may then stop 'cleverly' changing them back to US formats.

If this fails, try something more text-like, e.g. Totext({your.date}, "dd-MMM-yyyy").

Madawc Williams (East Anglia, UK)

 

[eo]

Do you mean I need to make these changes in the report itself? We have 100's of reports - that will not be possible. Surely BOExi must have a setting where you specify in which format the dates must be output?

EO
Hertfordshire, England

 

[Madawc]

Your question seems to be a question about how BOExi works, not Crystal. Try looking for a forum about it.

Madawc Williams (East Anglia, UK)

 

[Naith]

Hey EO,

Can you hook me up with a few details here? Like, when you said you set the regional settings on the server, who did you do this as? Was it using the same account that is responsible for running the BOE services? If not, do it like that.

Once you change these settings, reset the server to verify the changes take.

If this doesn't help, or you've already tried the above, hop onto your server again and look for helper_js.csp. This is the script that controls your date formats right here. Do a scan for DisplayDateTimeEN and check the date format. You'll probably find that it's in US format. Make the necessary change, save, and have another looksee.

If DisplayDateTimeEN isn't there (and I can't think why it would not be), but DisplayDateTime is there for other regions, like FR etc, then add

if (GetLang() == "en")
  Date.toCELocaleString = DisplayDateTimeEN

to the if clause where the other related region settings are.

You might have thrown some dgillz and madawc by posting in this section. I guess this is more CE. But give it a roll, and let us know how you got on.

Naith

 

[eo]

Will try this right away...will let you know!

Thanks

PS - I did not change the regional settings as the same account responsible for the BOE services...so thats going to be my first port of call.



EO
Hertfordshire, England

 

[eo]

Hi Naith

I have also posteed this in the CE forum, but that one is not as popular...

I thought that logging on to the server with the domain account which controls the services would solve the matter, alas, it did not, and the second suggestion re helper_js.csp, is not avaliable in BOExi, I think that was an old CE10 file.

Many thanks anyhow.



EO
Hertfordshire, England

 

[Naith]

Etienne,

So, you changed the regional settings with the account which is running the services and rebooted, and the problem's still there?

The helper_js.csp script may have an .asp extension now. Check for that too. Otherwise, as I don't have XI, ask BO what has replaced the afore mentioned script and change the date settings there.

Good luck.

Naith

 

[eo]

Naith

"So, you changed the regional settings with the account which is running the services and rebooted, and the problem's still there?" - yip

Will take the matter up with BO! Thanks for the help.

Etienne


EO
Hertfordshire, England